changing schema name after database restore

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Amit Asnani
    New Member
    • Mar 2012
    • 1

    changing schema name after database restore

    I have restore a database from the image file and that database has the schema name niranjan. Its allowing me to see the tables but not allowing me to see the data in the tables as its showing that you don't have permission to see data as you are not authorized to schema niranajan......

    error i am getting is:-

    com.ibm.db.Data Exception: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL0551N "AMIT" does not have the required authorization or privilege to perform operation "SELECT" on object "NIRANJAN.DISCA RDED_ENTRIES". SQLSTATE=42501


    pls help fast.........
Working...