Re: master db

Yes, you are correct.

Thanks
Hari

"Joh" <joh@xxxxxxxxxxxx> wrote in message
news:e8Yi%23k%23WFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
> 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: database user
    ... > SQL Server MVP ... >> What are the maximum limitation of database user? ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: DateFirst
    ... Hari ... SQL Server MVP ... > I have a stupid question. ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Button in a panel
    ... I have a search button inside a panel. ... performed when I hit the "Enter" key. ... Hari ... Prev by Date: ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: SQL7 to SQL2000 and hardware upgrade
    ... SQL Server MVP ... >I have a new box with W2003 Server to replace our existing W2000 ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Syntax errors
    ... Which version of SQl server is your old server? ... Hari ... SQL server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
Loading