rem -----------------------------------------------------------------------
rem Filename:   d2kowner.sql
rem Purpose:    List Oracle Designer Repository Owners
rem Date:       16-Aug-2000
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

select distinct owner
from   sys.dba_segments
where  segment_name = 'SDD_ELEMENTS';

REM D2K user privs:
REM
REM Run this from your PC as SYS to create role des2000_owner
REM     @c:\repadm20\utl\ckrorole.sql
REM grant des2000_owner to &&repos_owner;
REM 
REM grant execute on dbms_lock to &&repos_owner;
REM grant execute on dbms_pipe to &&repos_owner;
REM grant select on dba_rollback_segs to &&repos_owner;
REM grant select on dba_segments to &&repos_owner;
REM grant create sequence to &&repos_owner;
REM grant create synonym to &&repos_owner;
REM grant create table to &&repos_owner;
REM undef repos_owner
REM