Hello,
I have been assigned a task to restrict the SQL queries that our database users execute, based on the length of the query. we are using database vault for security. Can I know how can I get the length of the query that is currently being executed. SYS_CONTEXT gives me most of the user information, but when it comes to the SQL Statement, I'm not able to get the length of it. does SYS_CONTEXT('USERENV','CURRENT_SQL') gives me the query..? Please help.
Thanks!