Re: how to give create table permissions only
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 24 Jan 2008 15:18:46 -0800
(kulkarni.ninad@xxxxxxxxx) writes:
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.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- References:
- how to give create table permissions only
- From: kulkarni . ninad
- how to give create table permissions only
- Prev by Date: Re: SQL Stored procedure access?
- Next by Date: Re: Create PK / FK Tables Security
- Previous by thread: how to give create table permissions only
- Next by thread: Re: SQL Stored procedure access?
- Index(es):
Relevant Pages
|
|
