Privilege Management

After you create the users for an Oracle database system, they cannot connect to the database server nor do anything of consequence unless they have the privileges to perform specific database operations. For example, consider the following limitations:

ImageA user cannot connect to an Oracle database unless the user has the CREATE SESSION system privilege.

ImageA user cannot create a table in his or her corresponding schema unless the user has the CREATE TABLE system privilege.

A user cannot delete rows from a table in a different schema ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.