Post reply

Limiting statement permissions

  • November 9, 2005 at 4:10 am

    #169477

    Hi,

    Is it possible to grant statement permissions i.e. create function, create procedure to a user

    but to limit the permission to the user's own schema only e.g. user <User1> could create function <User1>.<NewFunction> but not dbo.<NewFunction>?

    Thanks.

    Regards,

    PK

     

     

     

  • November 9, 2005 at 7:49 am

    #603018

    You are talking about two things: permission and schema (same as owner in SQL 2000).

    grant statement just Grant the permissions of the commands.

    e.g. Grant create procedure to User1

    Whether User1 can create procedures owened by other users is determined by its database roles or server roles. If User1 is a member of sysadmin server role or db_owner database role, he can create procedures owned by either dbo or user1. If he is not a member of the roles, he can only create procedures owned by himself.

     

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

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