Oracle Programming/Controlling User Access

< Oracle Programming

Contents

Differentiating system privileges from object privilegesEdit

Granting privileges on tablesEdit

Viewing privileges in the data dictionaryEdit

Granting rolesEdit

syntax:GRANT role TO user example: GRANT dba TO scott

Distinguishing between privileges and rolesEdit