Re: Permissions not applied
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 20 Jan 2007 08:09:11 -0800
Mogens Nielsen - WM-Data A/S
(MogensNielsenWMDataAS@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I'm facing a weird problem trying to set permissions on a column in Sql
Server 2000. When using Enterprise Manager the permission on some
columns don't get applied, that is setting Select permissions on
Column1, Column2 and Column3 only saves the permission on Column1 and
Column2 but not on Column3. I tried setting the permissions with a GRANT
script in the Query Analyzer, but still without any luck.
Would it be possible for your to post the CREATE TABLE statement for
the table, and the GRANT statements you are using?
It would also be interesting to know how you conclude that the
permission is not applied.
--
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:
- Permissions not applied
- From: Mogens Nielsen - WM-Data A/S
- Permissions not applied
- Prev by Date: Permissions not applied
- Next by Date: Re: Permissions on views
- Previous by thread: Permissions not applied
- Next by thread: Re: Permissions not applied
- Index(es):
Relevant Pages
|
|
