Re: User can't access his own objects
From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/27/05
- Previous message: John Alfaro: "SQL 2005 Available Encrytion Algoriths by OS Version"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 27 Nov 2005 08:14:08 +0200
Hi
You'll have to move logins from Server A as well. How to do that? Search on
Google for 'sp_help_revlogin ' and you'll fined the answer
"JohnnyMagz" <JohnnyMagz@discussions.microsoft.com> wrote in message
news:5969529E-7A20-47D5-B904-0658E6C76381@microsoft.com...
> I'm fairly new to DBA tasks and I could use some help with this problem. I
> am
> trying to script out the structure of a database from server A and create
> that database on server B by running the script. I used Enterprise Manager
> to
> create the SQL Script. I selected a single table on the "General" tab; I
> took
> the defualts on the "Formatting" tab; and I selected all four Security
> Scripting Options from the "Options" tab.
>
> I ran the script without error, but when I attempted to run a select
> statement against a table owned by the user 'tims', Query Analyzer tells
> me
> that the object doesn't exist. I am able to access the object using it's
> fully qualified name. NOTE: a login for the user 'tims' already exists in
> this sql server. The uid and sid in sysusers do not match from server A
> and
> server B though.
>
> I suspect that I'm missing something - a rule about transferring
> logins/database accounts between servers. Please help if you can.
>
> Many Thanks!
> - Johnny
- Previous message: John Alfaro: "SQL 2005 Available Encrytion Algoriths by OS Version"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
