|Setting a data base role [message #694729]
||Sat, 09 July 2011 09:43
Registered: February 2010
my data base set-up requires that a data base role is set before any SQL is executed as the login/user receives it's permissions via the role, i.e. a
set role <my role>
is run before any other statement is issued against the data base.
I have found suggestions on the net this could be done in two ways:
1) using a stored procedure
2) using the afterOpen method of a data source.
ad 1) I have tried and found out this doesn't work as the security context will be reset after returning from the stored procedure to same it was prior to the execution of the procedure. So if I am not overlooking something, this doesn't help.
ad 2) I can unfortunatly not figure out (having basically no java scripting skills) how exactly the java script code would need to be looking and haven't found a sufficiently documented example. Can someone please share an example which shows how to do that and the exact syntax to use?
Powered by FUDForum
. Page generated in 0.02056 seconds