Oracle Help for the Web

Grant Object Privileges

Use this page to grant privileges that enable other Oracle database users (also known as schemas) and database roles to perform actions on an object. To grant a privilege, enter a Grantee, select a Privilege, then click Add.

To grant privileges on an object to another database user or role, you must have Manage access privileges on the schema that owns the object.

Field Descriptions

Grant Privileges

Field	Description
User/Role	Enter a database user or role to whom you want to grant privileges. Click to search for database users and roles. Note: To grant a privilege to all database users, choose Public.
Privilege	Select one or more object-level privileges. Privileges granted with the With Grant Option are shown in bold text.
With Grant Option	Select to enable the database user to grant access object privileges to other users or roles. Note: You can assign the With Grant Option to database users or Public, but not to database roles.
Add to List	Click to assign the privilege to the database user or role. The new privilege displays in the Revoke privileges list at the bottom of the page.

Revoke Privileges

Field	Description
User/Role	Displays the user or role to whom the privilege is granted. Click to remove all privileges from the database user or role.
Type	Displays the user type, either a Oracle database user or role.
Privilege	Displays the type of privilege.

Notes

The privileges you can grant are based on the type of object. For example, you can grant Execute privileges on a procedure or function, but not on a table or view.
You can grant some privileges to database users but not roles, for example the Reference privilege on a table. Check for error messages at the top of the page if the privilege you are trying to grant to a role does not appear in the Revoke Privileges list.

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Locating this Page

To locate this page in OracleAS Portal:

On the Portal Builder page, click the Navigator link.
Click the Database Objects tab.
In the Name column, scroll down to the schema whose contents you want to view.
Click the schema's name.
In the Name column, scroll down to the object .
Next to the object, click Grant Access.