| Groups | Blog | Home |
sql server clients : master db
master database? Thanks
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@Remove_this_For_Contacting.sqlserver2005.de> wrote in message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... [quoted text, click to view] > 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@mailcity.com> schrieb im Newsbeitrag > news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... > > if we create 1000 database users then is this create adverse effect on the > > master database? > > > > Thanks > > > > > >
here I am talking about application users.
[quoted text, click to view] "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:OYrFU49WFHA.3176@TK2MSFTNGP12.phx.gbl... > 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@mailcity.com> wrote in message > news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... > > 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@Remove_this_For_Contacting.sqlserver2005.de> wrote > > in > > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... > >> 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@mailcity.com> schrieb im Newsbeitrag > >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... > >> > if we create 1000 database users then is this create adverse effect on > > the > >> > master database? > >> > > >> > Thanks > >> > > >> > > >> > >> > > > > > >
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. [quoted text, click to view] "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:OYrFU49WFHA.3176@TK2MSFTNGP12.phx.gbl... > 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@mailcity.com> wrote in message > news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... > > 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@Remove_this_For_Contacting.sqlserver2005.de> wrote > > in > > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... > >> 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@mailcity.com> schrieb im Newsbeitrag > >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... > >> > if we create 1000 database users then is this create adverse effect on > > the > >> > master database? > >> > > >> > Thanks > >> > > >> > > >> > >> > > > > > >
You mean i have to create one table and put all the users in the table and
application hit that table right... [quoted text, click to view] "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:O74pHf#WFHA.2448@TK2MSFTNGP10.phx.gbl... > 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@mailcity.com> wrote in message > news:uvbyyU%23WFHA.1152@tk2msftngp13.phx.gbl... > > 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@hotmail.com> wrote in message > > news:OYrFU49WFHA.3176@TK2MSFTNGP12.phx.gbl... > >> 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@mailcity.com> wrote in message > >> news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... > >> > 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@Remove_this_For_Contacting.sqlserver2005.de> > >> > wrote > >> > in > >> > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... > >> >> 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@mailcity.com> schrieb im Newsbeitrag > >> >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... > >> >> > if we create 1000 database users then is this create adverse effect > > on > >> > the > >> >> > master database? > >> >> > > >> >> > Thanks > >> >> > > >> >> > > >> >> > >> >> > >> > > >> > > >> > >> > > > > > >
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@mailcity.com> schrieb im Newsbeitrag news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... [quoted text, click to view] > if we create 1000 database users then is this create adverse effect on the > master database? > > Thanks > >
Sorry some part missing of the answer... No, as of many hundred users there
is no feelable difference between a singleuser database to that one. "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> schrieb im Newsbeitrag news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... [quoted text, click to view] > 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@mailcity.com> schrieb im Newsbeitrag > news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... >> if we create 1000 database users then is this create adverse effect on >> the >> master database? >> >> Thanks >> >> > >
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 [quoted text, click to view] "Joh" <joh@mailcity.com> wrote in message news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... > 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@Remove_this_For_Contacting.sqlserver2005.de> wrote > in > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... >> 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@mailcity.com> schrieb im Newsbeitrag >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... >> > if we create 1000 database users then is this create adverse effect on > the >> > master database? >> > >> > Thanks >> > >> > >> >> > >
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 [quoted text, click to view] "Joh" <joh@mailcity.com> wrote in message news:uvbyyU%23WFHA.1152@tk2msftngp13.phx.gbl... > 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@hotmail.com> wrote in message > news:OYrFU49WFHA.3176@TK2MSFTNGP12.phx.gbl... >> 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@mailcity.com> wrote in message >> news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... >> > 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@Remove_this_For_Contacting.sqlserver2005.de> >> > wrote >> > in >> > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... >> >> 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@mailcity.com> schrieb im Newsbeitrag >> >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... >> >> > if we create 1000 database users then is this create adverse effect > on >> > the >> >> > master database? >> >> > >> >> > Thanks >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Yes, you are correct.
Thanks Hari [quoted text, click to view] "Joh" <joh@mailcity.com> wrote in message news:e8Yi%23k%23WFHA.2520@TK2MSFTNGP09.phx.gbl... > 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@hotmail.com> wrote in message > news:O74pHf#WFHA.2448@TK2MSFTNGP10.phx.gbl... >> 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@mailcity.com> wrote in message >> news:uvbyyU%23WFHA.1152@tk2msftngp13.phx.gbl... >> > 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@hotmail.com> wrote in message >> > news:OYrFU49WFHA.3176@TK2MSFTNGP12.phx.gbl... >> >> 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@mailcity.com> wrote in message >> >> news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... >> >> > 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@Remove_this_For_Contacting.sqlserver2005.de> >> >> > wrote >> >> > in >> >> > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... >> >> >> 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@mailcity.com> schrieb im Newsbeitrag >> >> >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... >> >> >> > if we create 1000 database users then is this create adverse > effect >> > on >> >> > the >> >> >> > master database? >> >> >> > >> >> >> > Thanks >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
This means you are managing user accounts within the application instead of
managing them via SQL Server. There are pros and cons to both but IMHO, the pros of managing the users in SQL Server or Windows (use integrated security) far outweigh the cons. Issues like accountability, security management and isolation, movement, etc... are all built into SQL Server and/or Windows whereas if you manage user account info manually, you have to write and maintain code to do that. It can certainly be done and most "older" apps do exactly that but the justifications for doing so get fewer and weaker with every iteration of the products. joe [quoted text, click to view] "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:%23jX0Tz%23WFHA.3140@TK2MSFTNGP14.phx.gbl... > Yes, you are correct. > > Thanks > Hari > > "Joh" <joh@mailcity.com> wrote in message > news:e8Yi%23k%23WFHA.2520@TK2MSFTNGP09.phx.gbl... >> 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@hotmail.com> wrote in message >> news:O74pHf#WFHA.2448@TK2MSFTNGP10.phx.gbl... >>> 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@mailcity.com> wrote in message >>> news:uvbyyU%23WFHA.1152@tk2msftngp13.phx.gbl... >>> > 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@hotmail.com> wrote in message >>> > news:OYrFU49WFHA.3176@TK2MSFTNGP12.phx.gbl... >>> >> 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@mailcity.com> wrote in message >>> >> news:usHtbi9WFHA.2664@TK2MSFTNGP15.phx.gbl... >>> >> > 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@Remove_this_For_Contacting.sqlserver2005.de> >>> >> > wrote >>> >> > in >>> >> > message news:uZmH2d9WFHA.2124@TK2MSFTNGP14.phx.gbl... >>> >> >> 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@mailcity.com> schrieb im Newsbeitrag >>> >> >> news:eJiTYc9WFHA.3348@TK2MSFTNGP14.phx.gbl... >>> >> >> > if we create 1000 database users then is this create adverse >> effect >>> > on >>> >> > the >>> >> >> > master database? >>> >> >> > >>> >> >> > Thanks >>> >> >> > >>> >> >> > >>> >> >> >>> >> >> >>> >> > >>> >> > >>> >> >>> >> >>> > >>> > >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |