February 23, 2011 at 9:06 am
I get this message for a recent login that I created..
Msg 262, Level 14, State 1, Procedure allergy_is_resolved, Line 27
CREATE FUNCTION permission denied in database 'Reporting'.
Can someone tell me the sql stmt for granting permissions to the login "mcwmmp" for
creating functions, stored procs and tables ( everything a developer needs to do )
Help is appreciated !
February 23, 2011 at 2:51 pm
Your best bet would probably be to make the user dbo, however it depends on the permission requirements of your particular db.
If you would like to grant the permissions explicitly the syntax is as below:
GRANT CREATE FUNCTION TO [YourUser];
GRANT CREATE TABLE TO [YourUser];
etc...
Andreas Goldman
February 23, 2011 at 3:03 pm
I advise to just talk to your sysadmin/dba and request what you want.
They will most likely be glad to point you to the request procedure or eventually the implemented segregation of duties in the development process.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 3:25 pm
Figured out! Done!
Thanks for the help.
Case closed
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply