Re: master db

You mean there is no harm in creating the database users.... or we have to
save all the users in the table and check their credential from there...

Thanks

"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uZmH2d9WFHA.2124@xxxxxxxxxxxxxxxxxxxxxxx
> Database users or only stored in the database, referenced to the server
> users on server level.
>
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
> "Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
> news:eJiTYc9WFHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
> > if we create 1000 database users then is this create adverse effect on
the
> > master database?
> >
> > Thanks
> >
> >
>
>


.

Relevant Pages

  • Re: Changing Password
    ... Passwords are assigned to logins which are at the server ... But that's at a server level, not the database ... I want the user john to be responsible for ...
    (microsoft.public.sqlserver.security)
  • Re: Cross DB ownership chaining problem
    ... About turning the option at the server level, I did that as a last resort ... > is that the owner of database D is different than the other databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Restrict number of connections to a databse.
    ... bear in mind that the connections is only configurable at a server level and ... not at a database level, ... also to finding the current active connections can be done by using sp_who2 ...
    (microsoft.public.sqlserver.programming)
  • Re: Restrict number of connections to a databse.
    ... bear in mind that the connections is only configurable at a server level and ... not at a database level, ... also to finding the current active connections can be done by using sp_who2 ...
    (microsoft.public.sqlserver.clients)
  • Re: Restrict number of connections to a databse.
    ... bear in mind that the connections is only configurable at a server level and ... not at a database level, ... also to finding the current active connections can be done by using sp_who2 ...
    (microsoft.public.sqlserver.server)