Database Role
From: Richard Siddaway (rsiddaw@hotmail.com)
Date: 05/17/02
- Next message: Jakob Persson: "Problems with SQL Srv. Agent and Proxy Account"
- Previous message: Richard Siddaway: "SQL Security"
- In reply to: Shahid Saleem: "Database Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Richard Siddaway" <rsiddaw@hotmail.com> Date: Fri, 17 May 2002 04:56:00 -0700
DBDATAWRITER can modify data does not get permission to
select data for viewing. to read the data the user needs
to be in db_datareader
Read the Books on Line articles on roles - especially the
overview - to see which roles you need to put users into
>-----Original Message-----
>Hye All
>
>I have added a new user in mydatabase named "ppaf" and it
belongs to
>Public and bddatawriter role , Now i loged on using this
user name but
>it havnt even select permission on any object in the
database. why so ?
>even it belongs to DBDATAWRITER role.
>
>
>Best Regards
>Shahid Saleem
>
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>
- Next message: Jakob Persson: "Problems with SQL Srv. Agent and Proxy Account"
- Previous message: Richard Siddaway: "SQL Security"
- In reply to: Shahid Saleem: "Database Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
