Database Creation - Ur Help needed..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Database Creation - Ur Help needed..

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

    Question

    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
    Nov 2001
    Posts
    118
    From that information it seems to me that there is a confusion problem with the schemas you are using.
    To resolve this issue I would see what happens if you prefix the table names in your statements with the appropriate schema name ( such as [schema].[tablename] ).

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