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
What are the advantages and disadvantages of using a database system. Sol. Advantages of Database System (DBMS) :  (1) Data Redundancy and Inconsistency: Since differen

Define cardinality and participation constraints on a relationship type, completeness constraint on generalization.        Ans: Cardinality defines the number of entities to wh

Chapter 1 - Profile for the Organization You have to select an organization of your choice and assume that you work for that organization. Now you must prepare a brief profile of t

In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later accordin

Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

can you resolve this for me please? Database Management Systems Homework 1 The following relations are given (primary keys are underlined): PLAY-ACTOR(AId, Name, Nationality, Birt

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

What are called multilevel indices? Indices with two or more levels are known as multilevel indices.