Re: master db

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: Granting EXEC for read only SPs
    ... Then, I created a database user, added it to the role 'X' to inherit the ... as the procedure and the accessed tables has the same owner. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • RE: Can you script preset values for forms?
    ... you can use the Load event of the form to populate the text boxes on ... login screen that requires a few pieces of information (SQL Server Name, ... number, SQL Database name, ID and Password) in addition to the Database User ...
    (microsoft.public.access.forms)
  • Re: Can you script preset values for forms?
    ... login screen that requires a few pieces of information (SQL Server Name, Port ... number, SQL Database name, ID and Password) in addition to the Database User ...
    (microsoft.public.access.forms)
  • Re: master db
    ... > In this case you can have a common database user and keep a application ... >>> It is always better to create SQL Server Logins rather than ... >>> Hari ... >>> 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)