About roles concept

From: Andrew Wong <andrew_at_i-cable.com>
Date: Wed, 31 Jul 2002 05:51:35 +0800
Message-ID: <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;

............................................
Received on Tue Jul 30 2002 - 23:51:35 CEST

Original text of this message