restricting rights

[bluecjh]

sql server 2005,

I have a user that seems to have rights shut
down, yet still they seem to be able to
delete tables in a database.

I can only think there is some kind of aliasing
going on, how do i get a list of any aliases
to the dbo account?

thanks for any help?



BlueCJH

 

[SimonEireconsulting]

what roles does the user belong to?

 

[bluecjh]

just one, i created MyRole which explictly denies
access to a table e.g.

DENY INSERT ON dbo.[t_PermissionsTest] to [MyRole]

one user who is also a member of MyRole cannot
insert into this table (as expected), but for the offending user they can...?

thanks

BlueCJH

 

[bluecjh]

turns out they have admin rights on the box.
this supercedes sql permissions.. ahh

BlueCJH