Re: Permissions not applied

Hi
I did some testing but not usimg EM and it seems to be worked fine
use demo

create table test (c1 int,c2 int,c3 int)
go
grant select on test to test --test no syadmin,db_owner
go
deny select on test (c3) to test
--connected as test

select * from test
--Server: Msg 229, Level 14, State 5, Line 1
---SELECT permission denied on object 'test', database 'demo', owner 'dbo'.

select c1,c2,c3 from test
--Server: Msg 229, Level 14, State 5, Line 1
---SELECT permission denied on object 'test', database 'demo', owner 'dbo'.

select c1,c2 from test
--works fine






"Mogens Nielsen - WM-Data A/S"
<MogensNielsenWMDataAS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC8AFD90-255F-4942-BC78-BE674669A1FE@xxxxxxxxxxxxxxxx
Hi everyone,
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.

Service Pack 4 has been applied to SQL Server 2000.

Has anyone had the same type of troubles setting permissions on columns?

TIA,

Mogens Nielsen


.

Relevant Pages

  • Re: Detailed User Access Rights
    ... Sysadmin role members have full SQL Server permissions and OS permissions ... > 2) Now that my customers can create their own views etc, ... GRANT SELECT ON MyTableFunction TO CustomerUser ...
    (microsoft.public.sqlserver.security)
  • Re: USERS group has the ability to change security permissions???
    ... Please use the Advance view in the NTFS permissions dialog to ... When there is a generic grant and a special grant to the same entity ... the RESULT: user level access can change NTFS ...
    (microsoft.public.win2000.security)
  • Re: DCOM Event ID 10015
    ... Grant the user permissions to start the COM component ... Run the MPSRPT_DirSvc.exe on the server box. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: NTFS woes
    ... "In some cases with a grant of Full is reduced ... NTFS permissions dialog. ... check Allow Delete Subfolders and Files ... Explicit Deny Delete on file does not work (user can still delete ...
    (microsoft.public.windows.server.security)
  • Re: NTFS woes
    ... "In some cases with a grant of Full is reduced ... NTFS permissions dialog. ... check Allow Delete Subfolders and Files ... Explicit Deny Delete on file does not work (user can still delete ...
    (microsoft.public.windows.server.security)