Re: owned schema or role members?



Bart
--db_datareader

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7d71fca8-ad8d-49c5-b4cc-c1cdab0fab43.htm


---db_datawriter
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/08a5c847-f993-4402-b3ac-a5113f41e8c8.htm


"Bart" <b@xxxxxx> wrote in message
news:OMfgIZlbHHA.3420@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I want to create a login (for account ASPNET from the Active Directory) in
sql server express 2005 for a specific database.
When addidng a new user to a specific database, i see:
Owned schemas, where i take db_datareader and db_datawriter
Roles members: also db_datareader and db_datawriter

What's the difference between both and are they both required fpr account
ASPNET?

Tbanks
Bart







.



Relevant Pages

  • Re: difference between Owned schemas and Roles members
    ... I want to create a login (for account ASPNET from the Active Directory) in ... sql server express 2005 for a specific database. ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.connect)
  • owned schema or role members?
    ... I want to create a login (for account ASPNET from the Active Directory) in ... sql server express 2005 for a specific database. ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • difference between Owned schemas and Roles members
    ... I want to create a login (for account ASPNET from the Active Directory) in ... sql server express 2005 for a specific database. ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.connect)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)