Categories:

System Functions (Control)

CLEANUP_DATABASE_ROLE_GRANTS

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

Syntax

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 CLEANUP_DATABASE_ROLE_GRANTS('mydb.dbr1' , 'myshare');
Copy