Accessing information permissions users, Database Management System

Assignment Help:

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;

Related Discussions:- Accessing information permissions users

Types of database, what are the type of the database

what are the type of the database

What is relational model feature, What is relational model feature? A r...

What is relational model feature? A relational model feature is much more data independence than some other database models.

Explain the dependency relationship of object oriented, Explain the depende...

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

Fragmentation, let us consider a table having 2200 records and the fixed si...

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

An Apriori algorithm, Submission Requirements All answers must be co...

Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)

Discuss difference between drop table r and delete from r, Discuss The diff...

Discuss The difference between drop table R and delete from R. DROP TABLE command deletes all the records with the table definition. This command will automatically committed

Adjustments are required to increase chances of inheritance, What types of ...

What types of adjustments are required to increase chances of inheritance. a) Some attributes can be added or ignored in the base class operation b) Some changes can be

Describe the association - design, Describe the Association: Design ...

Describe the Association: Design Before we describe association design let us define association "Association is set of links between two objects in the object model". It is

Datawarehouse Case studies, I have been given 8 differebt data warehouseing...

I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each

Explain the object-oriented decomposition, Explain the Object-oriented deco...

Explain the Object-oriented decomposition Object-oriented decomposition targets at identifying individual sovereign objects that encapsulate both a state and certain behavio

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages