Re: master db

You mean i have to create one table and put all the users in the table and
application hit that table right...

"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:O74pHf#WFHA.2448@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> In this case you can have a common database user and keep a application
> table to hold all the application users.
>
> Thanks
> Hari
> SQL Server Mvp
>
> "Joh" <joh@xxxxxxxxxxxx> wrote in message
> news:uvbyyU%23WFHA.1152@xxxxxxxxxxxxxxxxxxxxxxx
> > 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: master db
    ... In this case you can have a common database user and keep a application ... Hari ... SQL Server Mvp ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: how to restore
    ... There was typo error in Jens post. ... Hari ... SQL Server MVP ... >>> May I restore them into my new sql server? ...
    (microsoft.public.sqlserver.clients)
  • Re: Error 5123 Cannot Attach DB
    ... I will try the stopping of SQL Server and do the file move/renames after ... "Hari Prasad" wrote: ... >> I cannot copy the files as I get the same lock error. ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: prompt for parameter in a view
    ... SQL Server will not prompt for a user input. ... Hari ... SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)