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
i need to submit in this topic.

What is a Linked Server? Linked Servers is a method in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With

I am using Siteground. And my database is full of limit so need someone who reduces the data which no need. This is very simple and simple task. Skills required are Databa

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

What is meant by heuristic optimisation?  Discuss the main heuristics that are applied during query optimisation.  Ans:  In heuristic optimization, heuristics are employed to r

What are the various states through which a transaction passes through in its lifetime?  Briefly discuss all the events that causes transition from one state to another.   Ans:

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider

What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple