Re: Role inheritance?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 07 May 1998 16:20:24 GMT
Message-ID: <3556df1e.11709567@192.86.155.100>

A copy of this was sent to "Mark Aurit" <mark_aurit_at_mail.northgrum.com> (if that email address didn't require changing) On Thu, 7 May 1998 15:33:21 GMT, you wrote:

>Is it possible to easily inherit roles? For example, Role A lets me have
>to access to tables 1-10. I want to give Role B access to those tables
>and tables 11-20. Rather than specify tables 1-10 for Role B, can I just
>tell it
>to inherit the access rights from Role A?
>Thx, Mark

yes,

SQL> grant A to B;  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu May 07 1998 - 11:20:24 CDT