a bug in Enterprise Manager ?

if I use enterprise manager to change Login permissions, I
am prompted to confirm the password even if the password
is not changed. Worse thing is that most of the time I
don't know the login password , so I am not able use EM to
assign permissions. I have access to other computers with
SQL EM working, and if I need to I can still use QA. I use
my pc for most of the sql admin work and would like if I
can resolve this.
What should I do ?
Thanks in advanceSee if this helps:
FIX: You Are Prompted for Password Confirmation After You Change a Standard
SQL Server Login
http://support.microsoft.com/default.aspx?scid=kb;en-us;826161&Product=sql2k
Rand
This posting is provided "as is" with no warranties and confers no rights.

a bug in Enterprise Manager ?

if I use enterprise manager to change Login permissions, I
am prompted to confirm the password even if the password
is not changed. Worse thing is that most of the time I
don't know the login password , so I am not able use EM to
assign permissions. I have access to other computers with
SQL EM working, and if I need to I can still use QA. I use
my pc for most of the sql admin work and would like if I
can resolve this.
What should I do ?
Thanks in advance
See if this helps:
FIX: You Are Prompted for Password Confirmation After You Change a Standard
SQL Server Login
http://support.microsoft.com/default...&Product=sql2k
Rand
This posting is provided "as is" with no warranties and confers no rights.

a bug in Enterprise Manager ?

if I use enterprise manager to change Login permissions, I
am prompted to confirm the password even if the password
is not changed. Worse thing is that most of the time I
don't know the login password , so I am not able use EM to
assign permissions. I have access to other computers with
SQL EM working, and if I need to I can still use QA. I use
my pc for most of the sql admin work and would like if I
can resolve this.
What should I do ?
Thanks in advanceSee if this helps:
FIX: You Are Prompted for Password Confirmation After You Change a Standard
SQL Server Login
http://support.microsoft.com/defaul...1&Product=sql2k
Rand
This posting is provided "as is" with no warranties and confers no rights.

6.5 Group/User Permissions

Is there a way to easily disable Group/User access to a database without
having to either reset the permissions for the User and/or Group or drop the
User/Group.
In effect I want to selectively stop groups of users accessing a database
temporarily without the need to do major surgery on the object/user
permissions. Just switch them off for a short time, so to speak, and then
switch them back on again.
Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
PLEASE do not crosspost to so many different sections. One, or at most two,
is enough.
Kalen Delaney
MCSE, SQL Server MCT, MVP
ukndf wrote in message <73bvgs$4k5$1@.plug.news.pipex.net>...
>Is there a way to easily disable Group/User access to a database without
>having to either reset the permissions for the User and/or Group or drop
the
>User/Group.
>In effect I want to selectively stop groups of users accessing a database
>temporarily without the need to do major surgery on the object/user
>permissions. Just switch them off for a short time, so to speak, and then
>switch them back on again.
>Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
>
|||If you need to run SQL Server alone you can always start it with the single
user switch (check the docs)
If you are looking to disable users and all your security is handled via
groups you could write a short proc to move them to a group with no rights
and once you finished what you wanted to do, move them back in their groups.
Doing this would no require setting all the rights on the objects.

6.5 Group/User Permissions

Is there a way to easily disable Group/User access to a database without
having to either reset the permissions for the User and/or Group or drop the
User/Group.
In effect I want to selectively stop groups of users accessing a database
temporarily without the need to do major surgery on the object/user
permissions. Just switch them off for a short time, so to speak, and then
switch them back on again.
Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
PLEASE do not crosspost to so many different sections. One, or at most two,
is enough.
Kalen Delaney
MCSE, SQL Server MCT, MVP
ukndf wrote in message <73bvgs$4k5$1@.plug.news.pipex.net>...
>Is there a way to easily disable Group/User access to a database without
>having to either reset the permissions for the User and/or Group or drop
the
>User/Group.
>In effect I want to selectively stop groups of users accessing a database
>temporarily without the need to do major surgery on the object/user
>permissions. Just switch them off for a short time, so to speak, and then
>switch them back on again.
>Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
>
|||If you need to run SQL Server alone you can always start it with the single
user switch (check the docs)
If you are looking to disable users and all your security is handled via
groups you could write a short proc to move them to a group with no rights
and once you finished what you wanted to do, move them back in their groups.
Doing this would no require setting all the rights on the objects.

6.5 Group/User Permissions

Is there a way to easily disable Group/User access to a database without
having to either reset the permissions for the User and/or Group or drop the
User/Group.
In effect I want to selectively stop groups of users accessing a database
temporarily without the need to do major surgery on the object/user
permissions. Just switch them off for a short time, so to speak, and then
switch them back on again.
Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
PLEASE do not crosspost to so many different sections. One, or at most two,
is enough.
Kalen Delaney
MCSE, SQL Server MCT, MVP
ukndf wrote in message <73bvgs$4k5$1@.plug.news.pipex.net>...
>Is there a way to easily disable Group/User access to a database without
>having to either reset the permissions for the User and/or Group or drop
the
>User/Group.
>In effect I want to selectively stop groups of users accessing a database
>temporarily without the need to do major surgery on the object/user
>permissions. Just switch them off for a short time, so to speak, and then
>switch them back on again.
>Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
>
|||If you need to run SQL Server alone you can always start it with the single
user switch (check the docs)
If you are looking to disable users and all your security is handled via
groups you could write a short proc to move them to a group with no rights
and once you finished what you wanted to do, move them back in their groups.
Doing this would no require setting all the rights on the objects.