Re: owned schema or role members?

Bart
Does the user should run queries which manipulate with tables belong to
anohter SCHEMA?
I'd go with ROLES and grant SELECT/EXECUTE permission on SCHEMAs that the
user needs to query





"Bart" <b@xxxxxx> wrote in message
news:u1ddKM3bHHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
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?
    ... Schema or in Role members or in both? ... I want to create a login (for account ASPNET from the Active Directory) ...
    (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)
  • 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?
    ... 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: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)