|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
User Roles and PermissionHow 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 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 |
|||||||||||||||||||||||