| supernova 2002-11-20, 7:23 pm |
| Vishal,
Thanks for the advice.
Supernova
"Vishal Parkar" <vgparkar@hotmail.com> wrote in message
news:afbb01c29064$37cdd1c0$8af
82ecf@TK2MSFTNGXA03...
> Following system SP will return the information about the
> role. You can not explicitly find out permission granted
> to this role because db_Datareader has permission to see
> data from any user table in the database
>
> sp_dbfixedrolepermission 'db_datareader'
>
> --Vishal.
>
> >-----Original Message-----
> >How do you find out the permission for db_datareader role
> in a particular
> >db? When I click on the property of this role, it grays
> out. Thanks.
> >
> >
> >.
> >
|