rjackmanwyn
asked on
No Add Button
I just installed SQL 2008 and when I go into a stored procedure properties and permissions there is no add button. Am I missing something?
What version of SQL 2008 are you using?
What version of SQL 2008 are you using?
Use the search button to add the user or role to the list. Then select the user or role and set the permissions at the bottom of the screen.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If it is a system procedure or you are using an Express edition, you will need to use the GRANT command. See here for syntax.
http://msdn.microsoft.com/en-us/library/ms188371.aspx
http://msdn.microsoft.com/en-us/library/ms188371.aspx
ASKER
Thanks Nicobo
I thought in 2005 there was an add and delete button, but this works.
I thought in 2005 there was an add and delete button, but this works.