| Author |
How do I change the Server Role for a User
|
|
| sajid_yusuf@yahoo.com 2005-09-08, 1:23 pm |
| Hi!
When I create a new user in SQL Server (in the Enterprise manager) then
it is the only time when I get an option to choose from the list of the
server roles that I can grant to the user, but after that I don't know
how to view or change the server role for the user in Enterprise
Manager. I only found an option in Query Analyzer where you can run the
stored procedures. But I was wondering if there is a easy way to do it
in Enterprise Manager?
Thanks in advance
| |
| Perayu 2005-09-08, 8:23 pm |
| In EM, open the server role whitch you want to add to, then click on 'Add'
button.
Perayu
<sajid_yusuf@yahoo.com> wrote in message
news:1126202406.276571.186540@z14g2000cwz.googlegroups.com...
> Hi!
>
> When I create a new user in SQL Server (in the Enterprise manager) then
> it is the only time when I get an option to choose from the list of the
> server roles that I can grant to the user, but after that I don't know
> how to view or change the server role for the user in Enterprise
> Manager. I only found an option in Query Analyzer where you can run the
> stored procedures. But I was wondering if there is a easy way to do it
> in Enterprise Manager?
>
> Thanks in advance
>
| |
| Hari Prasad 2005-09-09, 3:23 am |
| Hi,
In Enterprise Manager -- Expand the SQL Server -- Go to Security Option --
Right click above Login name -- Properties --
go to Server roles Tab -- Click the roles you needed.
Thanks
Hari
SQL Server MVP
<sajid_yusuf@yahoo.com> wrote in message
news:1126202406.276571.186540@z14g2000cwz.googlegroups.com...
> Hi!
>
> When I create a new user in SQL Server (in the Enterprise manager) then
> it is the only time when I get an option to choose from the list of the
> server roles that I can grant to the user, but after that I don't know
> how to view or change the server role for the user in Enterprise
> Manager. I only found an option in Query Analyzer where you can run the
> stored procedures. But I was wondering if there is a easy way to do it
> in Enterprise Manager?
>
> Thanks in advance
>
| |
| sajid_yusuf@yahoo.com 2005-09-09, 7:23 am |
| Thank you. That really solved a big problem.
Hari Prasad wrote:[color=darkred
]
> Hi,
>
> In Enterprise Manager -- Expand the SQL Server -- Go to Security Option --
> Right click above Login name -- Properties --
> go to Server roles Tab -- Click the roles you needed.
>
> Thanks
> Hari
> SQL Server MVP
>
>
> <sajid_yusuf@yahoo.com> wrote in message
> news:1126202406.276571.186540@z14g2000cwz.googlegroups.com...
|
|
|
|