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
Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

#questiontypes of keys examples..

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat

Question 1: (a) Explain the legal meaning of :- (i) Computer Service Person (ii) Data holding (b) Explain how the law ensures Data protection and Security. Qu

i have assignments I don''t have time to finish because of work and other assignments, can you help with this? All are from the book Darabase design, application development and a

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t