Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> insufficient priviledges error when trying to grant select
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