Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Administration of Single User Application

Author  Topic 

ahdkhan
Starting Member

1 Post

Posted - 2011-02-26 : 15:25:13
Hello,
I recently join a company as a SQL Server DBA, The company purchased a web based erp using SQL Server 2008 as a back end. When I checked the DB I found the vendor made only one database level login. The application have a table with the name "tblusers" and all application users and passwords are saved in this table, they also controlling the user access through the application code and tables.
My problem is in my previous company all users are DB users and now I dont have experience to administer such kind of database.
While my Manager expected that database is always performed well.

Can anybody help or suggest me to administer such kind of application.
What should be the best way to administer such kind of software?

Regards,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-26 : 18:59:34
How this ERP is setup with users is the recommended approach. Your previous company did not follow the recommended approach for application users.

As far as administering it, there's no difference.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -