Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    4

    Unanswered: default public packages

    Hi

    I am configuring security parameters by following CIS Oracle Database Server 11 - 11g R2 .Here It is mentioning revoke default packages from public below,

    DBMS_ADVISOR
    DBMS_CRYPTO
    DBMS_JAVA
    DBMS_JAVA_TEST
    DBMS_JOB package
    DBMS_LDAP package
    DBMS_LOB package
    DBMS_OBFUSCATION_TOOLKIT
    DBMS_RANDOM
    DBMS_SCHEDULER
    DBMS_SQL package
    DBMS_XMLGEN
    DBMS_XMLQUERY
    UTL_FILE
    UTL_INADDR
    UTL_TCP
    UTL_MAIL
    UTL_SMTP
    UTL_DBWS
    UTL_HTTP
    UTL_ORAMTS
    HTTPURITYPE

    before taking any action i want to be sure whether it will make any effect on DB.If anybody knows about these security packages please advise.

    Oracle Release :- 11.2.0.2

    Thanks

    Regards
    Anas

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    be prepared to have errors thrown by previously working software packages.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2013
    Posts
    4
    Hello

    Can anyone make changes on these public packages in there Production or test environment .

    Please update if any documents.

    Thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    only a few objects have been granted to PUBLIC
    Code:
      1* select count(table_name) from dba_tab_privs where grantee = 'PUBLIC'
    SQL> /
    
    COUNT(TABLE_NAME)
    -----------------
                28708
    
      1* select count(table_name) from dba_tab_privs where grantee = 'PUBLIC' and table_name like 'DBMS%'
    SQL> /
    
    COUNT(TABLE_NAME)
    -----------------
                  203
    Last edited by anacedent; 07-22-13 at 00:54.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •