5. Assigning Privileges and Granting Permissions : Grant Overhead : Dbmsinfo—View Permissions for Current Session : Example: Return the Value of Query Row Limit for Current Session
 
Share this page                  
Example: Return the Value of Query Row Limit for Current Session
Assuming the Query_row_limit permission for the current session is 50, the following query returns the value “50” in x:
select x = dbmsinfo('query_row_limit') as x;
Note:  The dbmsinfo function allows other request_name values relating to other aspects of the current session. For details, see the chapter “Transactions and Error Handling” in the SQL Reference Guide.