Home All Groups Group Topic Archive Search About

User Roles and Permission

Author
30 Sep 2005 1:26 PM
Tony
How do I change user role/permission for a user/s  on time in different
databases if possible pls assist
thanks to Uri Dimant and R.D for my other post , it made a difference
--
Eager to Learn

Author
30 Sep 2005 3:23 PM
Jerry Spivey
Tony,

Preceed each database specific group of GRANT, REVOKE and DENY in your
script with the 'USE database' syntax to ensure the change in permissions
occur in the correct database context.

HTH

Jerry
Show quote
"Tony" <T***@discussions.microsoft.com> wrote in message
news:905F4F8E-CCF0-4E12-BD40-26A585F11668@microsoft.com...
> How do I change user role/permission for a user/s  on time in different
> databases if possible pls assist
> thanks to Uri Dimant and R.D for my other post , it made a difference
> --
> Eager to Learn

AddThis Social Bookmark Button