Re: master db

Over here is a call centre and when any new guys come to use application
they have created the database user for that.... this is totally wrong.



"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:OYrFU49WFHA.3176@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> There is no harm in creating more database users.
>
> we have to save all the users in the table and check their credential from
> there...???
>
> It is always better to create SQL Server Logins (secured) rather than
> storing users in normal user tables.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Joh" <joh@xxxxxxxxxxxx> wrote in message
> news:usHtbi9WFHA.2664@xxxxxxxxxxxxxxxxxxxxxxx
> > 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: Need Help with SQL Server Authentication
    ... > Ive got a Datagrid bound to a dataset connected to an SQL Server DB on the ... > Source Error: ... Private Sub Button1_Click(ByVal sender As System.Object, ... > I've added "system\ASPNET" to the database users but that didn't help. ...
    (microsoft.public.dotnet.framework.adonet)
  • Need Help with SQL Server Authentication
    ... Ive got a Datagrid bound to a dataset connected to an SQL Server DB on the ... Source Error: ... Private Sub Button1_Click(ByVal sender As System.Object, ... I've added "system\ASPNET" to the database users but that didn't help. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: master db
    ... There is no harm in creating more database users. ... It is always better to create SQL Server Logins rather than ... >>> if we create 1000 database users then is this create adverse effect on ...
    (microsoft.public.sqlserver.clients)
  • Re: DTS always breaks.
    ... button and uncheck "Copy database users and roles" and "Copy object level ... SQL Server MVP ... I have difficulty thinking that it may be a permissions ...
    (microsoft.public.sqlserver.dts)
  • Re: master db
    ... > There is no harm in creating more database users. ... > It is always better to create SQL Server Logins rather than ... >> You mean there is no harm in creating the database users.... ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)