DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle DB creation problem

  1. #1
    Join Date
    May 2001
    Location
    Dallas, US
    Posts
    78

    Arrow

    Hi Friends,
    I have to create an another oracle database in my solaris server, which has one more data base running with out any issues.

    Already I had created the existing data base as root user. Now i have to create one more database for testing purpose, so that i had created new database( called Sectest) through dbassist as Oracle user.

    This data base created sucessfully, and also created admin user, developer user.
    I gave grant permissions connect, resource, dba to dba user, and created development role .

    The following previllages assigned to Development role.
    Create any procedure, create procedure,
    Select any table, Insert any table, update any table,
    delete table, execute any procedure, alter any procedure,
    select any sequences, create any triger, alter any index, create session

    And then assigned Development role to dev user.

    Now i had create tables, and also public synonym for those tables.

    But the time of excuting my procedures in dev user, oracle gives an error as the table must be declared, even though tables are listing out when i gave describe command in dev user.

    Becuase of this i am struggling to reslove this issue.

    So please i need your to slove this problem.

    Thanks in advance.

    And i aslo i need more clarification in .profile part..

    Regards,
    Palani Kumar. R
    mail me to
    palanir@sakinfotech.co.in



    RP Kumar
    You Can Win, if u believe Yourself

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Procedures are generally executed with privileges assigned to the creator of procedure and not with the privileges available to the user executing the procedure.
    Was the procedure created in dev schema? if not, the user in whose schema the procedure exists must be given privilege for the tables referenced by the procedure.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

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


Click Here to Expand Forum to Full Width