Re: master db

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 ... >> You mean there is no harm in creating the database users.... ... Prev by Date: ...
    (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)