Is there some query by which i can find the string in question ?

Thanks opc. I was going through Policy based management and found it pretty interesting. To solve this default schema issue, is it fine to create a condition with field @DefaultSchema...

Then how can i manage to enforce dbo schema across my environment where hundreds of users are going to hit database sooner or later, each having created their default schema...

My problem is with users within NT group. SQl does not allow assigning default schema to NT groups. But I want all the users inside that group to have default...

Thanks Powell. Since I could not change the existing procedure, tried putting the result into table variable.

Okies. My mistake. After giving view database state permission to role R1, my user domain\U1 was able to check the DMV sys.dm_db_index_physical_stats but not sys.dm_db_file_space_usage. How can I find which...

I did that actually. But after doing this it shows "Query completed successfully". Thereafter when i logged in using user domain\u1, it gave me error saying "You do not have...

Ok I got he idea about the view server state. My confusion lies with view database state permissions.

1. I have this NT group domain\group1 which contains users domain\u1 and...

I've checked that granting Veiw database state to a role executes successfully. However the users having that roles mapped are still not able to access the DMVs.

Hello Lowel, Can't we similarly provide View server state and View satabase state to a ROLE ? I know that view server state permission can be given to server login...

Thanks Lars, thats what I wnated to know. I'll try that out and publish the results here. 🙂

We give our scripts to system DBAs to run. So we don't want them to know what our password is, thats why must_change option. Once we changed the password, can...

Lowell, Your queries were perfect. It's just another thing. Lets say I want this user U1 to have permissions to GRANT permissions to other users ???

what permission level should a role have to run gran permissions ?

Welsh, Sorry but it was not meant to hurt you or anyone. It was just out of affection for all respected people here in this forum.