Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> insufficient priviledges error when trying to grant select

insufficient priviledges error when trying to grant select

From: Jason Kratz <JasonKratz_at_excite.com>
Date: Thu, 9 Sep 1999 10:09:56 -0500
Message-ID: <7r8ile$9tm$1@flood.xnet.com>


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?

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-----
Received on Thu Sep 09 1999 - 10:09:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US