1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Roles in Oracle

Roles
A Database role is a group of privileges or objects that can be used to pass one or more privileges to one or more users. To control the levels of access different users with their corresponding user accounts will have in the EERSS, the specific privileges for each object have to be identified. Database roles have to associate these privileges with specific roles. First a set of roles has to be created.    

CREATE ROLE sysgenaccess;
        GRANT create session to sysgenaccess;
    CREATE ROLE sysadminuser;
        GRANT create session to sysadminuser;
    CREATE ROLE syspayroll;
        GRANT create session to syspayroll;

Two types of grants will be made. First, roles are given table access, i.e.

GRANT select ON Employee_Reim_Requests_V TO sysgenaccess;
GRANT select ON Client_Reim_Requests_V TO sysgenaccess;

GRANT select, insert, update ON Employee_BT TO sysadminuser;
GRANT execute ON Create_New_Request_SP TO sysadminuser;

GRANT select, insert, update ON Reim_Requests_BT TO syspayroll;

Then the roles are granted to the users.

GRANT sysgenaccess to olga;
GRANT syspayroll to peter;

When a role is granted to a user, it becomes one of that user?s default roles and is enabled at login time.

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy