Re: About roles concept
From: Mark D Powell <mark.powell_at_eds.com>
Date: 31 Jul 2002 06:10:25 -0700
Message-ID: <178d2795.0207310510.f40d230_at_posting.google.com>
Date: 31 Jul 2002 06:10:25 -0700
Message-ID: <178d2795.0207310510.f40d230_at_posting.google.com>
"Andrew Wong" <andrew_at_i-cable.com> wrote in message news:<ai71pc$pfh2_at_rain.i-cable.com>...
> How many roles that scott has?
> ..............................................
> CREATE ROLE role1;
> CREATE ROLE role2;
> CREATE scott IDENTIFIED BY 12343;
> GRANT role2 TO role1;
> GRANT role1 TO role3;
> GRANT role1 TO scott;
> ............................................
Andrew, this reads like a school assignement so rather than give you a direct answer why not:
log in to Oracle as a DBA
issue the commands
connect as scott
query the user_ dictionary views to get the answer
HTH -- Mark D Powell -- Received on Wed Jul 31 2002 - 15:10:25 CEST