Post reply

Create function and SP

  • November 1, 2016 at 8:30 am

    #331700

    All,

    I just granted a user with permission to create function and SP but he is getting this error "The specified schema name "dbo" either does not exist or you do not have permission to use it". I see he doesn have access to create a function and SP? I don't even know what I am missing? Any advise?

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • November 1, 2016 at 8:44 am

    #1909892

    It would be of some help if you post the code you used to grant permissions (with names changed).

    It would also help if you post if you got any messages after running the GRANT statements.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • November 1, 2016 at 9:04 am

    #1909898

    grant CREATE procedure TO

    GO

    grant CREATE FUNCTION TO

    GO

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • November 1, 2016 at 9:34 am

    #1909909

    check if the user has permissions for the dbo schema, they probably need:

    GRANT ALTER ON SCHEMA::dbo TO

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply