Accessing information permissions users, Database Management System

Accessing information about permissions to all users-Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name from oracle. In oracle the name of the table having these permissions is user_tab_privs.

DESCRIBE USER_TAB_PRIVS ;

 SELECT * FROM USER_TAB_PRIVS;

 

Posted Date: 3/11/2013 1:18:55 AM | Location : United States







Related Discussions:- Accessing information permissions users, Assignment Help, Ask Question on Accessing information permissions users, Get Answer, Expert's Help, Accessing information permissions users Discussions

Write discussion on Accessing information permissions users
Your posts are moderated
Related Questions
Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact

What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

Explain the ANSI SPARC architecture The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user

Define Database layer? The database layer defines the data formats used in the database.

FDs in Entities : Student entity :                                                Enrolment number →  Student name, Address Course Entity :

One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu

What is MySQL? MySQL is a relational database management system which has eleven million installations. It can be used for both Linux and Window. Managing database includes add