Help - Search - Members - Calendar
Full Version: single sign on utility for PLSQL or GUI developer
Oracle DBA Forums > Oracle > Oracle Forum
bostondba
Hi All,


We are looking for single sign on utility for PLSQL or oracle GUI developer tool. So we can assign UserB all the select permission on UserA schema (Current & future objects).

Currently, we have select Role UserA which we assigned to UserB and we use => (alter session set current_schema = UserA ) But we create lot of new objects (tables, view, mview...) and delete old ones very often and every time we have to assign the role select permissions.

Is there any easy way to do that?



Thanks In advance
aussie_dba
"We are looking for single sign on utility "

Use Oracle single-sign-on (SSO):

http://www.dba-oracle.com/application_serv...gle_sign_on.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.