Solved

Baseing a Datablock on DBA_ROLES

Posted on 2004-09-09
2
531 Views
Last Modified: 2012-06-27
I want to list all of the roles available in the database - This is for a maintenance form to create new users.  I want to allow someone to type in a user and password, and then click the checkboxes of the roles that they should be granted.  The problem is that with the wizard I can't find the DBA_ROLES as a table or a view to base the block on.  

Anyone got any idea how to do this.
0
Comment
Question by:Intern
2 Comments
 
LVL 7

Expert Comment

by:Bigfam5
ID: 12017792
You would need (select) permission to DBA_ROLES granted to the user executing the 'maintenance form'
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 12017840
just log in as SYSDBA

SQL>connect / as sysdba

SQL>select role from dba_roles;


or grant the log in user "select_catalog_role"


SQL>connect / as sysdba
SQL>grant select_catalog_role to <user_name>;

then log in as <user_name> to select from dba_roles....
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now