February 15, 2006 at 4:40 am
Hi, i have a db called BDinformix , The table's owners from this DB are : security and informix. When i take a backup from the db BDinformix to antoher computer running the same version of SQL Server, i could restore the db, but i forget to create the users (security and informix) before the restore (i made this after restore, so i couldnt delete the users from db). So if i want to make a query like :
SELECT * FROM table1
the server says "unknown object 'table1'" , but if i write
SELECT * FROM informix.table1
it works!! , so i was thinking "if i delete the users from Security->Logins and if I delete the db, i could do the process again , but i will create the users before restore the db, it will sure works " . But, it didn't work. I've been searching the web but nothing yet (i'm still searching) so any help would be a great healp for thi very very newbie
Thanks a Lot
Fred Lankovich
February 15, 2006 at 4:56 am
See BOL for sp_addlogin example E.
Basically create you Informix login on your new box so that it is identical to the Informix login on your old box.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy