Post reply

limited permission

  • March 11, 2019 at 9:25 am

    #409682

    I have a created new login.

    I want this new login to have limited permission - the ability to execute X number of stored procedures - nothing else.

    How do I go about this?

  • March 11, 2019 at 10:40 am

    #2024115

    Create a user for the login in the same database as the stored procedures.  Grant EXECUTE permission on the stored procedures to the user.  If the stored procedures are all in the same schema and there are no stored procedures on which you don't want to grant permission in the same schema, you can grant EXECUTE permission on the schema instead to simplify administration.

    John

  • March 11, 2019 at 11:32 am

    #2024122

    thank you

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

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