Oracle Programming/Controlling User Access

From Wikibooks, open books for an open world
Jump to: navigation, search

Differentiating system privileges from object privileges[edit]

Granting privileges on tables[edit]

Viewing privileges in the data dictionary[edit]

Granting roles[edit]

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

Distinguishing between privileges and roles[edit]