Q
Problem solve Get help with specific problems with your technologies, process and projects.

Granting different access rights to SQL and Forms and Reports

I would like to know how I can give access to users on SQL different from their access on FORMS and REPORTS?

Both SQL*Plus and the Oracle Developer products can make use of the DBMS_APPLICATION_INFO package to register the type of application. This can then be viewed in V$SESSION. SQL*Plus does this automatically for you. For FORMS and REPORTS, you can make the call to DBMS_APPLICATION_INFO directly.

You can change the user's access by enabling an AFTER LOGON trigger (available in 8i+). Have the trigger read V$SESSION to see which application was used. The trigger will then enable certain roles for the user depending on which application they used. The grants to these roles, along with the trigger will let you control access to different parts of the database for the same user with different applications.

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close