Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skybvi
Posting Yak Master
193 Posts |
 Posted - 2011-05-11 : 16:46:50
|
| Hi,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 BUTccr cant create table now also.Then, i ran:-grant create table on schema::dbo to ccrThen, it says Msg 102, Level 15, State 1, Line 0Incorrect syntax near 'CREATE TABLE..'.How shld i give permissions :Regards,SushantDBAWest Indies |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-11 : 21:20:15
|
| Add the user to ddladmin role |
 |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-05-12 : 09:28:09
|
| Can you plz explain, how to do thatRegards,SushantDBAWest Indies |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-12 : 09:41:29
|
| Login to SSMS -- > YourDatabase --> Security (tab) Right click on your desired user -- > Properties --- > in Database Role Membership click on db_ddladmin and press OK--------------------------http://connectsql.blogspot.com/ |
|
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-05-12 : 10:30:32
|
| Thanks...But didn't the ddladmin role gives more permissions than just creating a table...I think it gives permissions to all ddl statemnts..Am i right or correct me?Regards,SushantDBAWest Indies |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-12 : 11:15:53
|
| >> grant create table to ccr <<This should have worked. Do you have enough privelege yourself to grant? |
|
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-05-12 : 12:33:39
|
| I am logging in as sa..I guess it has all the privileges.Regards,SushantDBAWest Indies |
|
|
|
|
|
|
create table permsiiion