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
A database administrator''s responsibilities and data contents


Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Write a Query that uses the UNION Operator 1. Use the Software Experts database to:   a. Display the first and the last name of all consultants who worked on any projects f

List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas

Briefly explain what is to be done during defining problem statement. To define Problem Statement of a system, define what is to be done and how you can go to implement that. Y

Describe the types of Inheritance 1.  Single inheritance 2.  Multiple inheritance 3.  Hierarchical inheritance 4.  Multilevel inheritance

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row