how to give create table permissions only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kulkarni.ninad@gmail.com - 24 Jan 2008 16:57 GMT

I have situation over here where I need to give a user only create
table access to one of our environment. How do I do this? Is there any
way where I can create such a role? We're using Sql 2000 SP3a and
windows 2000.

Thanks,

Reply to this Message

Erland Sommarskog - 24 Jan 2008 23:18 GMT

> I have situation over here where I need to give a user only create
> table access to one of our environment. How do I do this? Is there any
> way where I can create such a role? We're using Sql 2000 SP3a and
> windows 2000.

I'm not really sure that I understand what you want to do, because if a
user is only able to create tables, there is not much he can do. But,
nevertheless, it's possible. Just add the user to the database wih
sp_adduser or sp_grantdbaccess, and then say:

GRANT CREATE TABLE TO thisuser

Or use a role if you feel like.

The user can now add tables in his own schema, but not in dbo.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message