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.

Examples

Example24.279.Example