Solved

Baseing a Datablock on DBA_ROLES

Posted on 2004-09-09
2
540 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

695 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