Friday, March 9, 2012

New login problem

Hi,

When i create a new login on my sql server 2005, i have a default database role selected. Is there a way to remove it or to modify it ?

Thanks

Zahir

Hi,

do you mean the public role ? This role cannot be removed or disabled.

Try to make the role secure an grant not that many rights to it.


HTH, Jens Suessmeyer.


http://www.sqlserver2005.de
-

No comments:

Post a Comment