Re: owned schema or role members?
- From: "Bart" <b@xxxxxx>
- Date: Mon, 26 Mar 2007 20:55:25 +0200
"Uri Dimant" <urid@xxxxxxxxxxx> schreef in bericht
news:OOCCsw3bHHA.4000@xxxxxxxxxxxxxxxxxxxxxxx
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
Thanks, but I still don't understand the difference between giving the Role
db_datareader / db_datawriter to user 'aspnet' and adding user 'aspnet' to
Schema dbdatareader and Schema db_datawriter ...
.
- Follow-Ups:
- Re: owned schema or role members?
- From: Erland Sommarskog
- Re: owned schema or role members?
- References:
- owned schema or role members?
- From: Bart
- Re: owned schema or role members?
- From: Uri Dimant
- Re: owned schema or role members?
- From: Bart
- Re: owned schema or role members?
- From: Uri Dimant
- Re: owned schema or role members?
- From: Bart
- Re: owned schema or role members?
- From: Uri Dimant
- owned schema or role members?
- Prev by Date: Re: User ID issue - urgent
- Next by Date: Re: User ID issue - urgent
- Previous by thread: Re: owned schema or role members?
- Next by thread: Re: owned schema or role members?
- Index(es):