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
What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords

What is a candidate key? Minimal super keys are known as candidate keys.

i want answers this assignment now if yiu can maket for me now ?

There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag

File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:

Explain ODBC? ODBC - Open DataBase Connectivity (ODBC) enable the integration of SQL along with a general-reasons programming language.


Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou