Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 25, 2010 07:41 AM by ScottV.
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?)
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?
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.