Application Role and access second database
Posted
by
lszk
on Stack Overflow
See other posts from Stack Overflow
or by lszk
Published on 2014-06-05T09:23:27Z
Indexed on
2014/06/05
9:24 UTC
Read the original article
Hit count: 151
security
|sql-server-2012
I have written a script to create an audit trails to my database in a second one db. So far I had no problems during tests on my dev machine from SQL Server Management Studio. Problems started to occurs when I first tried to test my triggers from my application by modyfing data in it. Using profiler I found out, that my audit trails db is not visible in sys.databases, so here lies the problem. The application using an Application Role, so as I found on MSDN, that's why I can't get access to other db on the server.
I'm not a DBA. I have no experience with properly settings the security stuff, so please guide me, how can I set the setting for guest account (according to MSDN) to get access to this db? I need to have a record for this database in sys.databases and I need to be able to insert data in this database in all tables. No select, update or delete I need.
© Stack Overflow or respective owner