Oracle Programming/Controlling User Access

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

Contents

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]

Retrieved from "http://en.wikibooks.org/w/index.php?title=Oracle_Programming/Controlling_User_Access&oldid=1978776"