Name
DB.DBA.RDF_ALL_USER_PERMS_DEL — Removes all the setting of permissions of an user, both default permissions and permissions on specific graphs.
Synopsis
DB.DBA.RDF_ALL_USER_PERMS_DEL
(
|
in uname varchar , |
in
uid
integer := null
); |
Description
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.
Parameters
uname
User name
uid
The user U_ID in the system table DB.DBA.SYS_USERS.