Re: Assign permissions to allow updates but deny select on table
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 11 Jul 2007 21:24:24 +0000 (UTC)
Tanzen (aaron.nasby@xxxxxxxxx) writes:
Some of the commands you show in your example don't seem to work for
me. I am running SQL 2000. Forgive my ignorance, but I'm not sure what
those commands should be in SQL 2000
I hope you've now learnt that you should always say which version of SQL
Server you are using. :-)
Below is the SQL 2000 version of the script that I posted. By the way,
you did not include the full text of your error message.
sp_addlogin Julle, 'Vetebulle'
go
sp_adduser Julle
go
CREATE TABLE spezial (a int NOT NULL,
secret varchar(23) NOT NULL)
go
GRANT DELETE, INSERT, UPDATE, SELECT ON spezial TO Julle
go
DENY SELECT ON spezial (secret) TO Julle
go
INSERT spezial (a, secret) VALUES (1, ')(2344')
INSERT spezial (a, secret) VALUES (13, '25344')
go
SETUSER 'Julle'
go
DELETE spezial WHERE a = 13
go
SETUSER
go
DROP TABLE spezial
EXEC sp_dropuser Julle
EXEC sp_droplogin Julle
--
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
.
- Follow-Ups:
- References:
- Assign permissions to allow updates but deny select on table
- From: Tanzen
- Re: Assign permissions to allow updates but deny select on table
- From: Erland Sommarskog
- Re: Assign permissions to allow updates but deny select on table
- From: Tanzen
- Assign permissions to allow updates but deny select on table
- Prev by Date: Re: Access Sql server 2005 from .net class library
- Next by Date: Re: Login/Account Lock
- Previous by thread: Re: Assign permissions to allow updates but deny select on table
- Next by thread: Re: Assign permissions to allow updates but deny select on table
- Index(es):
Relevant Pages
|
