3. 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 DBMSINFO Function section of the SQL Language Guide.