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

I use
sp_addrolemember 'db_datareader', 'myrole'
sp_addrolemember 'db_datawriter', 'myrole'
and everything works ok except for stored procedures (I get a "permission
denied for EXECUTE"). Which member should I use for this?

Thanks again.

"Evergray" <forlists@xxxxxxx> wrote in message
news:OJH%23pZkMGHA.1180@xxxxxxxxxxxxxxxxxxxxxxx
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: Validate user permission
    ... Joe Kaplan-MS MVP Directory Services Programming ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ... authenticated user can modify a given attribute (member is the one you ... there is an advanced permission called "Write ...
    (microsoft.public.dotnet.security)
  • RE: "Send As" permission resetting on SBS
    ... permission of the user account that is a member of one of administrative ... groups will be reset to match the ACL of the AdminSDHolder thread. ... Directory domain controller that holds the primary domain controller ...
    (microsoft.public.windows.server.sbs)
  • RE: "Send As" permission resetting on SBS
    ... permission of the user account that is a member of one of administrative ... groups will be reset to match the ACL of the AdminSDHolder thread. ... Directory domain controller that holds the primary domain controller ...
    (microsoft.public.windows.server.sbs)
  • Re: Validate user permission
    ... Thanks a lot for the reply Joe! ... authenticated user can modify a given attribute (member is the one you are ... which is the only attribute in the Write Members permission ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.security)
  • Re: Validate user permission
    ... Windows auth so that you can use the user's security context to talk to AD ... authenticated user can modify a given attribute (member is the one you are ... which is the only attribute in the Write Members permission ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.security)