469,090 Members | 1,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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

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
3 4435
"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
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
"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.

Similar topics

25 posts views Thread by Yves Glodt | last post: by
32 posts views Thread by Adrian Herscu | last post: by
8 posts views Thread by Bern McCarty | last post: by
14 posts views Thread by Patrick Kowalzick | last post: by
399 posts views Thread by =?UTF-8?B?Ik1hcnRpbiB2LiBMw7Z3aXMi?= | last post: by
12 posts views Thread by puzzlecracker | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.