Re: Run report in another's schema

The owner of the table can grant rights to anyone ( or everyone with grant select on table_name to public).. If you do not want others to have to use the fully qualified table name ( owner.tablename) have the owner create a synonym for it like
create synonym my_table for owner.my_table; grant select on my_table to some_other_user;

"S k u l l s p i t" <dotacionNOSPAM_at_yahoo.com> wrote:

>In our current custom developed system, individual users cannot run and view
>reports unless they are login as the schema owner. However, they can create
>reports.
>
>For example, one developer can create reports, but she would like to share
>her reports with other users. I could not make it work, even tho I have set
>the directory privileges to all read, executables.
>
>Any ideas?
Received on Thu Jul 24 2003 - 13:55:19 CDT