Browse by Tags

Site sponsored by:

RSS Feeds

sql server 2005 » security (RSS)

Re: getting error 15284 when attempting to drop user in a database

Hi, You have to change the owner for the view defination to another user, and ensure that their would be no object mapped to this particular login/user (jefftest) and then you can remove it.

Posted to SQL Server 2005 General DBA Questions (Forum) by ghemant on 08-26-2008
Re: What permssions/roles to be assigned to a database user who is in charge of jobs?

Hi, You can assign SQLAgentUserRole to it, please refer http://msdn.microsoft.com/en-us/library/ms188283.aspx Regards

Posted to SQL Server 2005 General DBA Questions (Forum) by ghemant on 08-22-2008

Page 1 of 1 (2 items)