July 21, 2008 at 12:31 am
The roles that the users are assigned to. The object level permissions that the users have (if applicable)
The first you can query from sys.database_role_members and sys.database_principals. The second you can query from sys.database_permissions and sys.database_principals
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 4:29 am
[font="Verdana"]
GilaMonster (7/20/2008)
vidhya sagar (7/20/2008)
(You can update the tables if you connect to server as DAC)You can read the system tables if you connect with the DAC. Updating them is still not possible.
Hi Gail,
You can check the below blog where they says updating system table is possible with DAC in single user mode.
Regards..Vidhya Sagar
SQL-Articles
July 21, 2008 at 4:37 am
I know about that, you didn't mention the single user mode last time. Hence the comment that the DAC alone is not sufficient to update system tables.
Also, while it is possible, updating the system tables is something that should only be done as an absolute last resort, not just to make things 'easier'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 9:11 am
Idera has a free download of their product called SQL Permissions. I've used it several times and it works great.
Tim White
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply