Title: RE: VIEWS/ROLES/PRIVS
no she
doesn't. she will be creating the view in her own
schema.
now if
she was to be creating the view in JOE's schema, then she would need create any
view.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Whit
[EMAIL PROTECTED] wrote:
>
> I'm just doing a sanity test on my befuddled brain.
>
> I have a schema owner called JOE which owns a bunch of tables.
> While logged into the instance as JOE, he does the following -
> SQL> GRANT SELECT ON BASE_TABLE TO STD_ROLE;
> While logged into the instances as
Title: RE: VIEWS/ROLES/PRIVS
Sue also needs the CREATE ANY VIEW system privilege.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
I'm just doing a sanity test
Privileges received via a role cannot be used to create stored objects
(e.g., views, packages). JOE will have to grant SELECT on the table to
SUE WITH GRANT OPTION in order for her to create the view.
PB
--- [EMAIL PROTECTED] wrote:
>
> I'm just doing a sanity test on my befuddled brain.
>
> I
I'm just doing a sanity test on my befuddled brain.
I have a schema owner called JOE which owns a bunch of tables.
While logged into the instance as JOE, he does the following -
SQL> GRANT SELECT ON BASE_TABLE TO STD_ROLE;
While logged into the instances as SYS, I do the following -
SQL> GRANT ST