You can drop access rights to the Oracle Data Miner repository by executing the dropusergrants script.
dropusergrants.sql user_access
For example, the following statement drops the access rights that were granted to dmuser1.
@dropusergrants dmuser1
As with the usergrants script, 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. When you drop the access rights for the target user, all proxy and LDAP users that are based on that target user automatically lose access to the repository.
Related Topics