September 26, 2008 at 4:00 am
Hi - I have some users who should have View Definition rights on all (user) databases. I would like to create a new server role but hasn't found a way to do it. Is it possible?
If not - what do you think? Create a new application role in the MODEL database with "view definition" rights and then add users to the role.
Anyone solved this in any way?
September 26, 2008 at 6:55 am
You cannot create server level roles. Maybe a flaw in the security design. I suppose you could do it by creating a role in model.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 30, 2008 at 3:11 am
Hello,
If your users are within a Windows Group then you could create a Login for the group (if it doesn't already exist) and then execute the following:-
Use master
Go
Grant View Any Definition To MyUserGroup
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply