Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query for System Profile For Responsabilties

Status
Not open for further replies.

bgreen

Programmer
Feb 20, 2003
185
CA
HI,

I need a query that will retun All responsabilities system profile values for profile 'Printer'.

Where can I get this info????
 
Hi,
Perhaps a language problem, but your question is not clear.

What do you mean by 'Responsibilties'?

Profiles usualy set limits, not assign duties..





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 

Try:

DBA_SYS_PRIVS
DBA_TAB_PRIVS
DBA_ROLE_PRIVS

[3eyes]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
When I am in the Oracle APPS logged in as System Admin You can set System Profile Options for a Responsability, such as Printer Option. I was wondering how I could query that?

ex.

Resp:
Oracle General Ledger Super User

What printer is assigned to this resp. at system level?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top