Re: SQLServer 2000: Assign permissions on ALL tables to an app role

just use sp_addrolemember 'db_datareader', 'Your_App_role'

--
WBR, Evergray
--
Words mean nothing...



"Gaspar" <gaspar@xxxxxxxxxx> wrote in message
news:OBkt4OkMGHA.3984@xxxxxxxxxxxxxxxxxxxxxxx
In SQL Server 2005 I can assign SELECT/INSERT/UPDATE permissions on all
tables to an application role, but in SQL Server 2000 I can't find how to
do this. For an user it's easy because I can make it member of the
db_datareader and db_datawriter, but I can't do this for an application
role.

Any ideas? Please don't tell me to assign permissions on each
table/view/stored proc because I don't want to do that.

Thanks!



.

Relevant Pages

  • Re: Alter Many Stored Procedures
    ... permissions to create/drop/alter other objects as well. ... a member of the db_ddladmin fixed database role ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Roles in Roles
    ... For a database user it is easy to find the database roles the user is a ... role is a member of. ... On SQL 2005 permissions is more intricate than ever, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: General permission question
    ... through the steps again I discovered that my permissions were fine. ... The account establish security credentials before database permissions can ... sysadmin server role member, then the account connects with sysadmin rights. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Object level permissions for roles
    ... Generally, I don't use DENY. ... Columnist, SQL Server Professional ... For one role I only want read permissions therefore for I have ticked SELECT ... However for a user A who is a member of role R (which has all ...
    (microsoft.public.sqlserver.security)
  • Re: Authentication and impersonation
    ... Most probably user_A is member of a group that has permissions on the ... Check the groups that have access to SQL server including ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)