Effective Permissions for QA and EM

I am looking for information regarding permissions needed to be able to run
1) the Query Analyzer and 2) Enterprise Manager.
Since we are required to revoke all access from the public role, all
inherited permissions needed to run the above applications are gone. I
can't seem to find any documentation on which objects are needed in order to
make those functional for a particular role.
Thanks in advance,
AllenHi,
To open a database in Enterprise manager or Query Analyzer you should be
user in that partcular database. Then to access the object
you should have minimum select rights on table and exec rights on procedures
Thanks
Hari
"A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
news:uCpzs$v5GHA.4304@.TK2MSFTNGP03.phx.gbl...
>I am looking for information regarding permissions needed to be able to run
>1) the Query Analyzer and 2) Enterprise Manager.
> Since we are required to revoke all access from the public role, all
> inherited permissions needed to run the above applications are gone. I
> can't seem to find any documentation on which objects are needed in order
> to make those functional for a particular role.
> Thanks in advance,
> Allen
>|||Thanks for your reply.
I understand you have to be a user in that database, but since I revoke all
access from public, simply adding a user to a database has a net result of
nothing. I need to know /specifically/ which objects the user would need
explicit access to.
Examples include:
- system tables in master
- sprocs and extended sprocs in master
- views in master (syslogins? sysconstraints?)
- system tables in user databases they need access to
etc...
I can take care of all the user objects - I need to know about system
objects. I can't just assign people to the db_owner database role either -
I need to grant them just enough privileges to use those two applications,
but no more.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uh8vHs15GHA.4112@.TK2MSFTNGP04.phx.gbl...
> Hi,
> To open a database in Enterprise manager or Query Analyzer you should be
> user in that partcular database. Then to access the object
> you should have minimum select rights on table and exec rights on
> procedures
> Thanks
> Hari
>
> "A McGuire" <allen.mcguire@.gmail.com.invalid> wrote in message
> news:uCpzs$v5GHA.4304@.TK2MSFTNGP03.phx.gbl...
>