1. DATABASE LOAD problem with NT SQL Server
We had a crash last week and I had to recover the database. Before I can
load the old contents, I needed to arrange the tables appropriately, so I
generated all the tables from scripts, created default user and login and
then loaded the backup file with LOAD DATABASE.
Problem is, LOAD DATABASE loads the contents of all tables (which already
exist in the database), sets permissions to the default user and owner of
the tables, but trashes the database information. I set up the database
to login with, say XXX, and get to be user YYY, which is the owner of all
the tables in the database. After LOAD DATABASE, I can still login as
XXX, but I get to be dbo, no access permissions to the tables of user YYY.
Apparently, there is no way to change the user associated with a login,
once the login exist. And I can't drop the login, since dropping the
login also drops the user, and that user has tables in the database.
Since my front-end (Access 2.0) communicates with the SQL Server by
logging in, I lose all access to the tables.
Is there any way to change the user of a login, without creating a new
user. Or am I loading the database backup the wrong way?
Tel: ++972-9-504182 time in which you realize that you've just
made a BIG mistake --Wired
2. Few spots open for Application Developers training at Univ of Penn
3. Oracle8 SQL*Loader - Problem loading fixed format files with no line termination characters
4. How to update???
5. Oracle8 on NT vs. Oracle8 Netware
6. How to get the return value of Update
7. Oracle8 & NT Multithreading problems
8. Storing Excel speadsheat in ASE 11.5
9. Oracle8.1.7 on NT-Problems
10. Oracle8 performance problems under NT
11. NT\Oracle8 services problem
12. Oracle8.0.4 on NT / jobs problem
13. Problem: Oracle8.0.5 on NT 4.0 SP3