Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CREATE FUNCTION permission denied in database Expand / Collapse
Author
Message
Posted Wednesday, February 23, 2011 9:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:13 PM
Points: 178, Visits: 252

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 !
Post #1068345
Posted Wednesday, February 23, 2011 2:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 18, 2012 12:24 PM
Points: 45, Visits: 124
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
Post #1068561
Posted Wednesday, February 23, 2011 3:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:35 AM
Points: 6,733, Visits: 8,485
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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #1068566
Posted Wednesday, February 23, 2011 3:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:13 PM
Points: 178, Visits: 252
Figured out! Done!
Thanks for the help.

Case closed
Post #1068581
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse