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.
Re: cannot acees two databases as owner ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ... (microsoft.public.sqlserver.setup)
Re: SQL Login ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP... > But how do we add the User X to the sysadmin / ... (microsoft.public.sqlserver.security)
Re: System Administrator Implied Permissions ...member of the dbo group and you are automatically given ... Now, given this, why does SQL Server... Much Thanks Dan.... (microsoft.public.sqlserver.security)
Re: Cross VPN Domain Authentication ... When VPN connected from my non-domain member computer,... SqlConnection class to connect to SQL Server via domain authentication, ... former is a one-off way to do it; the latter causes a login prompt when the ... (microsoft.public.sqlserver.security)
RE: Interdev not creating project (authenticate failure) ... | 1st Computer (for SQL Server and IIS): ... | Member of: Administrators ... Also in IIS console, rightclick the web site and go to properties/directory ... Integrated Windows and check Basic authentication.... (microsoft.public.inetserver.iis.security)
