Sybase Revoke Command

Revoke command is used to remove the permissions granted to users, groups or roles. SSO can run Revoke command.

Sybase Revoke Command Syntax:

revoke [grant option for] all | permission_list on
object [column_list] from user_list
[cascade]

Examples:

1. Revoke create database from the user test.

use master
go
revoke create database from test
go

2. Revoke select permissions from the user george from the table employee on database r2schools

use r2schools
go
revoke select on employee from george
go