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
Why does a DBMS query language is designed? A DBMS query language is designed to support end users who use English-like commands. support in the development of complex applicat

Explain the components of Database System in details.

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?


Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial

What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID

What are the aggregate objects in the data dictionary? Views Match codes Lock objects.

Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su

Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program

What is system catalog or catalog relation? How is better known as? A RDBMS maintains a explanation of all the data that it contains, information about every relation and index