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
Discuss The difference between drop table R and delete from R.  DROP TABLE command deletes all the records with the table definition. This command will automatically committed

please i request for your assistance in developing a case-based online phone repair

Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

Define value set? Value set: It is a set of values. You do not always need a user to enter junk free text within all the fields. Therefore, Oracle Apps uses value set to valida

Use of partial data by applications : In common, applications work with views rather than whole relations. Thus, it may be more appropriate to work with subsets of relations rather

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c)  Garbage collection

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000. (SELECT d_name FROM dept WHERE d_code IN (SELECT d_c