I need to get the application directory from report server. I wrote System.AppDomain.CurrentDomain().BaseDirectory() in the expression. It works when I click preview in IDE. But it doesn't work when I deploy on the server. How come?
Because BaseDirectory requires CAS FileIOPermission. Try creating an utility assembly and registering it in rssrvpolicy.config. You may need to assert FileIOPermission as well.
sqlHi, i am trying to find permissions on SQL server database tables for a usergroup defined in Active Directory.
there is one function in SQL : “SELECT * FROM fn_my_permissions('TableName', 'OBJECT')”
This function get me the permission on TableName table for the current user. but i want that inforamtion for a user group defined in AD.
Is tehre any way to acheive that?
-Mani
The best (and probably only) way is to login as a member of the AD Group and run the query on sys.fn_my_permissions.
HTH,
-Steven Gott
SDE/T
SQL Server
Hi, i am trying to find permissions on SQL server database tables for a usergroup defined in Active Directory.
there is one function in SQL :“SELECT*FROM fn_my_permissions('TableName','OBJECT')”
This function get me the permission on TableName table for the current user. but i want that inforamtion for a user group defined in AD.
Is tehre any way to acheive that?
-Mani
The best (and probably only) way is to login as a member of the AD Group and run the query on sys.fn_my_permissions.
HTH,
-Steven Gott
SDE/T
SQL Server
