Database Security Products (MOSC)

MOSC Banner

Granting select to table------------giving error

edited Jul 20, 2010 2:13AM in Database Security Products (MOSC) 13 commentsAnswered
Hello,
I logged in sys "/as sysdba"

and granting privileges to other users like   >>grant select on <schema_name>.<table_name> to <username>;
but its giving error like

ERROR at line 1:
ORA-01031: insufficient privileges

Im having all sysdba privileges
GRANTEE                        GRANTED_ROLE                   ADM
------------------------------ ------------------------------ ---
SYS                            ALL_OBJECTS                             YES
SYS                            AQ_ADMINISTRATOR_ROLE          YES
SYS                            AQ_USER_ROLE                        YES
SYS                            CONNECT                                  YES
SYS                            CUSTOM_PUBLIC                         YES
SYS                            DBA                                            YES
SYS                            DELETE_CATALOG_ROLE            YES
SYS                            EXECUTE_CATALOG_ROLE           YES
SYS                            EXP_FULL_DATABASE                     YES
SYS                            GMRADMIN                                      YES
SYS                            HS_ADMIN_ROLE                            YES
SYS                            IMP_FULL_DATABASE                     YES
SYS                            JAVADEBUGPRIV                            YES

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center