Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 25, 2010 07:41 AM by ScottV.
Member
1 Points
21 Posts
Aug 12, 2010 02:08 AM|LINK
On SQL server I have set up an account as db owner with password for database.(is this correct?)
Star
11118 Points
1997 Posts
Aug 12, 2010 03:46 AM|LINK
means only Administrator or db owner can access this database.
if you want to access it, no need to do so. for security point of view, you have done right.
Aug 13, 2010 12:59 AM|LINK
since this is a club web site with login, is this still correct?
50 Points
15 Posts
Aug 25, 2010 07:41 AM|LINK
Depends on what exactly you are trying to do. Based upon the small amt of info you provided in your question, here's what I'd do:
1. create an application login for the application.
2. GRANT CONNECT permissions to the database to that login
3. GRANT <whatever> permissions within that database to the login
This way the application's not using the sa account to do it's business.
Regards,
Scott
daaaon
Member
1 Points
21 Posts
Club starter kit version 3 c# database issue
Aug 12, 2010 02:08 AM|LINK
On SQL server I have set up an account as db owner with password for database.(is this correct?)
nareshguree2...
Star
11118 Points
1997 Posts
Re: Club starter kit version 3 c# database issue
Aug 12, 2010 03:46 AM|LINK
means only Administrator or db owner can access this database.
if you want to access it, no need to do so. for security point of view, you have done right.
daaaon
Member
1 Points
21 Posts
Re: Club starter kit version 3 c# database issue
Aug 13, 2010 12:59 AM|LINK
since this is a club web site with login, is this still correct?
ScottV.
Member
50 Points
15 Posts
Re: Club starter kit version 3 c# database issue
Aug 25, 2010 07:41 AM|LINK
Depends on what exactly you are trying to do. Based upon the small amt of info you provided in your question, here's what I'd do:
1. create an application login for the application.
2. GRANT CONNECT permissions to the database to that login
3. GRANT <whatever> permissions within that database to the login
This way the application's not using the sa account to do it's business.
Regards,
Scott