Re: owned schema or role members?

Well, i want to create a new login for account ASPNET (which runs under
ASP.NET) and then define an user (aspnet) for 'mydatabase'. That user must
get read/write prights to the db. At that level, i see in the window
configuration two things about read /write: Owned Schema and Role members.
So my question is: should i take db_readreader / db_writer in the Ownd
Schema or in Role members or in both?
Thanks

"Uri Dimant" <urid@xxxxxxxxxxx> schreef in bericht
news:%23p8We%232bHHA.4632@xxxxxxxxxxxxxxxxxxxxxxx
Bart

SCHEMA and Roles are different things. When you create a user ut should be
mapped to schema you have specified ir DEFAULT schema--DBO.
Can you elaborate on what you are trying to achive?


"Bart" <b@xxxxxx> wrote in message
news:uEq8NwvbHHA.4140@xxxxxxxxxxxxxxxxxxxxxxx
Thanks, but my question was more about the difference between Owned
schema and Role members.
Is it enough to take db_anything in Role members or must the user also
owns a schema with db_anything?

"Uri Dimant" <urid@xxxxxxxxxxx> schreef in bericht
news:eDumYbsbHHA.2088@xxxxxxxxxxxxxxxxxxxxxxx
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: owned schema or role members?
    ... but my question was more about the difference between Owned schema ... Is it enough to take db_anything in Role members or must the user also owns ... I want to create a login (for account ASPNET from the Active Directory) ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • Re: owned schema or role members?
    ... configuration two things about read /write: Owned Schema and Role members. ... Schema or in Role members or in both? ... I want to create a login (for account ASPNET from the Active ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • Re: owned schema or role members?
    ... SCHEMA and Roles are different things. ... Is it enough to take db_anything in Role members or must the user also ... I want to create a login (for account ASPNET from the Active Directory) ... When addidng a new user to a specific database, ...
    (microsoft.public.sqlserver.security)
  • Re: EXECUTE permission denied on object aspnet_CheckSchemaVersion
    ... I've created a database in Sql Server 2005 for my asp.net project. ... 'Test', schema 'dbo'. ... I see that there are several owned schema and role members starting with ... aspnet_ should I enable these settings for this user or is there a better ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast