I need to find out what the 'Required' permissions on on the ASPState database? We have been granting dbo to the login. Thanks.
I finaly figured out how to do this, I created a database role. and assigned implicit permissions to the stored procedures for the ASPState database. The assigned the owner to be dbo. Then I assigned the custom role to the login that needed access. This way I avoided applying db_owner permissions to the ASPState database for my login.
No comments:
Post a Comment