Re: insufficient priviledges error when trying to grant select

A copy of this was sent to "Jason Kratz" <JasonKratz_at_excite.com> (if that email address didn't require changing) On Thu, 9 Sep 1999 10:09:56 -0500, you wrote:

>Hello all....I'm fairly new to Oracle and ran across the following
>yesterday...
>
>I was trying to grant select priviledges on a table in one schema to a
>different user. I was logged in using INTERNAL (also tried this from
>SYSTEM). when I ran the statement I received the error that I didnt have
>sufficient priviledges to do this. Does SYS/INTERNAL not have all
>priviledges? I also logged in directly as SYS as well with the same result.
>I ended up logging in as the user that owned the table and doing it that way
>but I found it very strange that with a DBA account I couldnt do this. Any
>ideas?

only the OWNER of a table OR someone who has been granted SELECT on that table WITH GRANT OPTION can grant on an object.

SYS/INTERNAL can select any table but in order to transfer that privelege, they must have been granted select with grant option.

>
>Thanks,
>
>Jason
>
>-----BEGIN PGP PUBLIC KEY BLOCK-----
>Version: PGPfreeware 6.5.1 for non-commercial use <http://www.pgp.com>
>
>mQENAzfV3/cAAAEIAL715WZYbg1wK7hTbmgbMR9dYuNN2eGWimVS1kEzaOtmMty4
>XEIIBTRC0D6XTw4hPVi2iS8iYuZuMkMlIpgmBoczIZzX2Q8+yHQc9ysajNyniaC8
>kHwPttYq/RDaedtCPRQ4HaaNqh/lnkXDexW1LhqzzmbVWFtUlwsFBtJbKPgQTMxB
>isLtzvRXOiynbv5kJ+YQO/SwP4ftJFzSMIAjOnCvAOTRecneaBWDZUt2b5A9QvWt
>bCu4sWs8ro/Om9M1uXNdUQ7aalLVj9KMS/eRCG1UgqTNgF+ggPjgGYUhaPlqiwwN
>iqFCBdFGpr0QpA/JZNIuRXMgmsBQwt1ExJdO+lkABRG0IUphc29uIEtyYXR6IDxq
>a3JhdHoxQGhvdG1haWwuY29tPokBFQMFEDfV3/fC3UTEl076WQEBQOYH/ioi/c5L
>GqQqgERJGw9TV68c6kYykFq5D7vFDuO9p8LpWKIvAiX390V51smGrtVta+3xjYJh
>U62uR1ECIleH0zN/Z9j3DxqdXy6lcJmXfzTFaBwyO+zADUGACYQO3aZbqIQfMy2B
>XvrcRuD5M8gWad4exYOQwYDLMdLJio3DDgD8NcJ4UjOIYESM/vcxpHi0zxxop0b1
>Xsq0rq4zXb+Qwd+2AgmdxUVpSc3yBpOzxpBOmMcopQ7mTk2ujRY0lr13CfAulLZZ
>mTcNQKW9SimzObHZsxqZ7wWihVHCdKnxXgR0e3m4NlSs47eim2Bb/QMWmJ7EsWq7
>AkloLkYxPU7E7Rw=
>=bFyQ
>-----END PGP PUBLIC KEY BLOCK-----
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 09 1999 - 10:24:21 CDT