Example of grant create session to mca12, Database Management System

Example-GRANT CREATE SESSION TO MCA12;

(This command gives system level permission on creating a session - not portable)

GRANT SELECT ON EMP TO MCA12;

(Object level permission on table EMP)

GRANT SELECT, UPDATE, INSERT, DELETE ON EMP TO MCA12;

GRANT SELECT, UPDATE ON EMP TO MCA12, MCA13;

(Two users)

GRANT ALL ON EMP TO PUBLIC;

(All permission to every users, do not use it. It is very risky for database)

Revoke: It is used to revoke the permission granted.

 

 

Posted Date: 3/11/2013 1:16:51 AM | Location : United States







Related Discussions:- Example of grant create session to mca12, Assignment Help, Ask Question on Example of grant create session to mca12, Get Answer, Expert's Help, Example of grant create session to mca12 Discussions

Write discussion on Example of grant create session to mca12
Your posts are moderated
Related Questions
Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for


#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

What is the use of Union and intersection operation? Union: The result of this operation contains all tuples that are either in r1 or in r2 or in both r1 and r2.Duplicate tuple

It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.


Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Define the Attribute Inheritance The attributes of a higher level entity set are inherited through a lower level entity set made by specialization-generalization hierarchy. Nam

I have to solve a problem using access