System level permissions-data control, Database Management System

System level permissions: With the use of data dictionary you can view them.

      Let us take the table name as user_sys_privs (used in oracle).

      DESCRIBE USER_SYS_PRIVS ;

      SELECT * FROM USER_SYS_PRIVS ;

All these commands are very definite to a data base system and may be dissimilar on dissimilar DBMS.

DATABASE OBJECTS: VIEWS, SEQUENCES, INDEXES AND SYNONYMS

 Some of the important concepts in a database system are the views and indexes.

Views are a mechanism that can support data independence and security. Indexes help in better query responses. Let us discuss about them along with two more concepts sequences and synonyms in more details.

 

Posted Date: 3/11/2013 1:19:27 AM | Location : United States







Related Discussions:- System level permissions-data control, Assignment Help, Ask Question on System level permissions-data control, Get Answer, Expert's Help, System level permissions-data control Discussions

Write discussion on System level permissions-data control
Your posts are moderated
Related Questions
" Wound-wait" scheme : It is based on a preemptive method. It is based on a simple rule:                   If Ti requests a database resource that is held by Tj

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Identification of concurrency Identification of concurrency: Dynamic model identifies concurrency. Two objects are said to be parallel (concurrent) if they can receive events a


need a DBMS system on any data for assignment.

What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base

Performance of Various Concurrency Control Mechanisms

Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?


What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflow? When a record is inserted, the bucket to that