December 23, 2008 at 5:27 pm
One of the user has dbo right but cannot drop the table in the database.
Here what I did.
User is the member of the NT group which does not have dbo access. only read/write access.
created user in sql who is the member of the NT group and gave dbo rights.
when user try to drop the table he created got access denied. why.
Is it because NT group is taking the precedence on individual users.
December 23, 2008 at 8:16 pm
I've seen this before.
sp_helprotect might show you some things.
Remember that DENY statements take precedence over grants.
Craig Outcalt
December 24, 2008 at 2:46 am
Hi
Can we see permissions for a particular owner like own1 ?by any stored procedure or any way?
Thanx
Thanks
December 24, 2008 at 10:43 am
Yes, You can do that by using following function.
SELECT * FROM fn_my_permissions(null, 'database');
December 24, 2008 at 10:52 am
Remember too that SQL 2005 has metadata visibility "issues".
so if you don't own it you won't see it in the results in stored proc or fuction output
Craig Outcalt
December 25, 2008 at 10:06 pm
THX all...
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply