Hi Freinds,

I want to give "create table" permission to another user "with grant option".

Iam giving following command

grant create table to uatdbo with grant option

where uatdbo is a user name in that database .

It's giving following error

Msg 156, Level 15, State 2:
Server 'DEVP', Line 1:
Incorrect syntax near the keyword 'with'. following command

Pl. rectify where is the error ??
Regards
Surya

suraj_c (AT) hotmail (DOT) com (suraj kumar) wrote in message news:<64719074.0404281016.c8357ce (AT) posting (DOT) google.com>...
Hi There!

One cannot use the "with grant option" when granting access to DDL
commands (such as "create table"). It is only available when granting
object access permissions such as select, update, etc.

Cheers!!

Sara ...