Granting Access Rights Using a Script

You can grant access rights to the repository by executing the usergrants script and specifying a user name. The repository must be already installed before you run the script.

usergrants.sql user_access

For example, the following statement grants Oracle Data Miner access to the user dmuser1:

@usergrants dmuser1

The user name that you specify must be a target user. Any proxy or LDAP users that authenticate based on this target user automatically acquire the permissions of the target user.