Sybase Grant command

To assign permissions to users, groups and roles, we use grant command.

Sybase Grant Syntax:

grant {all | command_list} to user_list

Here user_list can be users, groups or roles.
command_list can be create, execute, insert, delete, update, select,..

Examples:

1. Grant create table permissions to user ‘george’.

grant create table to george.
go

2. Grant all permissions to user george

grant all to george
go

3. Grant create database to users test and george

To grant permission create database to any user, user must be added to master database. Otherwise it will through error.

use master
go
sp_adduser test
go
sp_add george
go

grant create database to test, george
go

4. Grant execute permission to user test login_spoc.

grant execute on login_spoc to test
go