By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,550 Members | 1,733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,550 IT Pros & Developers. It's quick & easy.

How can a 'non-owner' grant access to a table.

P: n/a
Hello all, I have a question regarding Oracle9i security.

I have a database owned by 'admin' all tables in the database are
owned and originally created by admin.

I have a role on this database named: Role1

If admin creates a new table named: 'new_table' I want another user,
say John to be able to GRANT SELECT ON new_table TO Role1;

This grant does not succeed ? Does anyone know how I can accomplish
this.

Thanks in advance.

Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"David Pylatuk" <da*********@centurysystems.net> wrote in message news:<Fo********************@news20.bellglobal.com >...
Hello all, I have a question regarding Oracle9i security.

I have a database owned by 'admin' all tables in the database are
owned and originally created by admin.

I have a role on this database named: Role1

If admin creates a new table named: 'new_table' I want another user,
say John to be able to GRANT SELECT ON new_table TO Role1;

This grant does not succeed ? Does anyone know how I can accomplish
this.

Thanks in advance.


The owner must have GRANTED with ADMIN option.
Note: you are well advised NOT to implement this, because you will get
a myriad of grants, and you may easily loose control.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

P: n/a
Could you clarify please.

Do you mean the owner must have granted with admin to the role ?

<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...
"David Pylatuk" <da*********@centurysystems.net> wrote in message

news:<Fo********************@news20.bellglobal.com >...
Hello all, I have a question regarding Oracle9i security.

I have a database owned by 'admin' all tables in the database are
owned and originally created by admin.

I have a role on this database named: Role1

If admin creates a new table named: 'new_table' I want another user,
say John to be able to GRANT SELECT ON new_table TO Role1;

This grant does not succeed ? Does anyone know how I can accomplish
this.

Thanks in advance.


The owner must have GRANTED with ADMIN option.
Note: you are well advised NOT to implement this, because you will get
a myriad of grants, and you may easily loose control.

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #3

P: n/a
"David Pylatuk" <da*********@centurysystems.net> wrote in message news:<MK********************@news20.bellglobal.com >...
Could you clarify please.

Do you mean the owner must have granted with admin to the role ?


Yes, I did mean that. Otherwise, no joy, unless you are on 9i and use
SYS to bypass security. Grants made by SYS, however, are not exported
in a logical dump, as SYS is not exported

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.