Re: User Role Permissions
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/25/04
- Next message: SqlJunkies User: "Password Management Policy in SQL 2000"
- Previous message: Bish: "User Role Permissions"
- In reply to: Bish: "User Role Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 25 Nov 2004 06:58:52 -0600
You can use DCL (data control language) statements to grant permissions to
your new role. Use GRANT to add permissions, REVOKE to remove permissions
and DENY to prevent granted permissions from being inherited. Note that
DENY is used only in special cases since a normal user/role will not have
any object permissions unless explicitly granted.
Sample script below. See the Books Online for more information.
GRANT SELECT ON MyView TO MyRole
GRANT ALL ON MyTable TO MyRole
GRANT EXECUTE ON MyProcedure TO MyRole
-- Hope this helps. Dan Guzman SQL Server MVP "Bish" <Bish@discussions.microsoft.com> wrote in message news:C6B05E5D-07AB-4C11-AF1A-B44B478BE4E9@microsoft.com... > sIs there a system stored proc that provide access to changing the > permissions on a user role. > > I am using the sp_addrole to create a role and sp_addrolemember to add a > member but wish also to script certain permissions in the new role. > > ....thanks
- Next message: SqlJunkies User: "Password Management Policy in SQL 2000"
- Previous message: Bish: "User Role Permissions"
- In reply to: Bish: "User Role Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
