Browser Detection Script checks if Internet Explorer 5.5 is being used and adjusts the font size if it is.
Oracle Help for the WebContentsIndexSearchView Topic

Edit a Schema: Grants

Skip Navigation Links| Field Descriptions | Related Help Topics | Additional Information | Locating this Page |

 

Use this page to grant to the schema database object privileges such as SELECT, INSERT, UPDATE, DELETE or EXECUTE. You can grant or remove privileges for one or more objects shown on the page by checking or unchecking the appropriate check boxes next to it, then clicking Apply.

Sample Schema Page

If an object does not appear on the page, type its name in the Object combo box and click Add to add it to the page.

Object names display on this page by object type (Sequences, Table/Views, Procedures/Functions/Packages, etc).

Go to topField Descriptions

 

Field Description
Object

Enter the the name of a database object on which you want to grant privileges. You are granting privileges on this object to the schema shown in the upper left corner of the page. In the figure above, database object privileges are being granted to MY_SCHEMA.

Click Browse to search for objects.

Note: Prefix the name of the object with the schema that owns it, for example, SCOTT.EMP to indicate the EMP table in the SCOTT schema.
Add Click to add the object to the list at the bottom of the page. Objects display by object type. In the figure above, SCOTT.EMP displays under Tables/Views.
EXECUTE Select to give the selected schema privileges to execute the object, for example, a procedure or trigger.
INSERT Select to give the selected schema privileges to insert rows into the table or view.
UPDATE Select to give the selected schema privileges to update table or view rows.
DELETE Select to give the selected schema privileges to delete table or view rows.

Go to topRelated Help Topics

Next Steps:

Go to topAdditional Information

On Portal Center:

Go to topLocating this Page

To locate this page in OracleAS Portal:

  1. On the Portal Builder page, click the Navigator link.
  2. Click the Database Objects tab.
  3. In the Name column, scroll down to the schema you want to edit.
  4. In the Actions column next to the schema, click Edit.

Copyright © 2005, Oracle. All rights reserved.