May 30, 2006 at 6:44 pm
How can I assign a SQL Server Login the security of being able to read data from a database and create views? I am relatively new to SQL Security and have been asked to figure this out.
The users needs access to read data and create views within a multiple databases.
Thank you in advanced for the assistance.
May 31, 2006 at 3:50 am
Using Query Analyser
GRANT CREATE VIEW TO <user>
GRANT SELECT ON <table> TO <user>
-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
May 31, 2006 at 11:37 am
Thank you Grasshopper. This worked like a charm. Now, here is an additional request that I am puzzled with.
User Request
I am able to create views successfully. After starting work on this I also need authorization to create user-defined functions. SQLServer date/time fields need to be converted to the SAP format within the view. Rewriting this code over and over again per datafield in the view will be a maintenance headache, so I would like to create a user-defined function instead.
Thank you in advance for this assistance.
June 1, 2006 at 8:57 am
The syntax would be:
GRANT CREATE FUNCTION TO <user>
-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
June 1, 2006 at 9:03 am
Kind of figured that one as well. Thank you for your assistance.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy