DB.DBA.RDF_ALL_USER_PERMS_DEL — Removes all the setting of permissions of an user, both default permissions and permissions on specific graphs.
|in uname varchar ,
|in uid integer := null
This function removes all the setting of permissions of user named uname, both default permissions and permissions on specific graphs. The only exception is that it does not remove default permissions if the specified user is "nobody" or "dba", but all graph-specific permissions are always removed.
The procedure can deal with disabled users. Moreover it can be used with entirely deleted users as soon as user id is known. It is possible to pass NULL instead of user name and an integer user ID as a second argument.
The user U_ID in the system table DB.DBA.SYS_USERS.