Sybase revoke permission

In this article, we are going to see how to revoke permissions from Sybase user on a table(s).

Sybase Revoke Syntax:

revoke [grant option for] 
	{all [privileges] | permission_list} 
	on {table_name [(column_list)] 
		| view_name [(column_list)] 
		| stored_procedure_name | function_name
		| keyname}
	[with {pred_name | {all |no} predicates}]
	from {public | name_list | role_list}
	[cascade]
	[granted by grantor]

To verify the list of permissions granted on a table to user.

sp_helprotect tablename, username
go

Example:

sp_helprotect emp, kiran
go

Output:

1. Revoke update permission from the user ‘kiran’ on the table ’emp’

revoke update on emp from kiran
go

2. Now remove the all the permissions granted on table ‘dept’ to user ‘michael’

revoke all on dept from michael
go

3. Verify the permssions after revoke by below command

sp_helprotect dept, michael
go

For video tutorial, please check this and subscribe my channel if it is useful.