Re: User/table access issues

["sk8save" <webforumsuser@xxxxxxxxxxxxxx>]

I was talking with a DBA friend and I think we figured it out.

 I was logged into the database using userX's credential. I ran a simple SQL 
and it didn't find the table unless I prefixed it using userX.

 I looked at the security side of things for userX and the user wasn't mapped 
to that database in question. I'm assuming that this is the cause. In my case, 
I can't map the user due to the way I imported the backup (I get an error while 
trying to map due to the user already being in the database - or something like 
that).

 My goal is to figure out how to import the DB properly without creating the 
user in the database. Then, I could simply create the login and map it to the 
database and in theory, I'd be done - I think.