I am trying to give a user (ccr) to create table permission in 1 of db's.
I ran this:-
grant create table to ccr
it says command done successfully
ccr cant create table now also.
Then, i ran:-
grant create table on schema::dbo to ccr
Then, it says
Msg 102, Level 15, State 1, Line 0
Incorrect syntax near 'CREATE TABLE..'.
How shld i give permissions :