Categories:

System functions (Control)

SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS¶

Revokes privileges on dropped objects from the share and grants the database role to the share.

Syntax¶

SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS( '<database_role_name>' , '<share_name>' )
Copy

Arguments¶

'database_role_name'

The name of the database role.

If the identifier is not fully qualified in the form of db_name.database_role_name, the command uses the database role in the current database for the session.

'share_name'

The name of the share.

Access control requirements¶

To call this function, the active role must have the global MANAGE GRANTS privilege.

Usage notes¶

None.

Example¶

Call the function:

SELECT SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS('mydb.dbr1' , 'myshare');
Copy