Post reply

DO i need to?

  • March 2, 2006 at 7:39 am

    #170816

    Hi

    Do a web admin also needs complete access to the databases just as sql admin. Does any of the deployment process needs sql admin previlages.

  • March 2, 2006 at 10:29 am

    #624391

    It depends on the application. If the application has functionality to add users and it is using Standard authentication  then a person who adds users / logins have to have securityadmin rights in SQL Server for example. Or if the application has a functionality to backup database then the person who is using the app has to have these rights. These are just examples.

    It is a responsibility of the web admin to make sure the application works and he or his QA engineer will have to do a validation testing. So they need so much rights in SQL Server as application functionality provide.

    Additionally the applications during the deployment normally create databases, so the web admin needs this right as well.

    So far 98% of the third party applications I work with have a prerequisite of an administrative login in SQL Server.

    Regards,Yelena Varsha

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply