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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • David Pylatuk
    #1

    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.



    Tags: None
    • sybrandb@yahoo.com
      #2
      Re: How can a 'non-owner' grant access to a table.

      "David Pylatuk" <davepylatuk@ce nturysystems.ne twrote in message news:<FoFvc.312 64$Hn.1016242@n ews20.bellgloba l.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

        Comment

        • David Pylatuk
          #3
          Re: How can a 'non-owner' grant access to a table.

          Could you clarify please.

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

          <sybrandb@yahoo .comwrote in message
          news:a1d154f4.0 406040208.676b9 ca7@posting.goo gle.com...
          "David Pylatuk" <davepylatuk@ce nturysystems.ne twrote in message
          news:<FoFvc.312 64$Hn.1016242@n ews20.bellgloba l.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

            Comment

            • sybrandb@yahoo.com
              #4
              Re: How can a 'non-owner' grant access to a table.

              "David Pylatuk" <davepylatuk@ce nturysystems.ne twrote in message news:<MKZvc.370 79$Hn.1208160@n ews20.bellgloba l.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

                Comment

                Previous template Next
                Working...