Permission Problems

Brian DonahueBrian Donahue Posts: 6,590 New member
edited April 20, 2004 6:18AM in SQL Compare Previous Versions
Hi Lee,

You may want to check that the 'Ignore Permissions' option is turned
off. If you're migrating database objects with SQL Compare without moving
the permissions on them, you might be missing some important rights for your
particular login.

Please give that a look and tell us if you have any success.

Regards,

Brian Donahue
Red Gate Technical Support

"Lee Barrett" <[email protected]> wrote in message
news:[email protected]
> Firstly I am no expert with SQL.
>
> Up until now I only have a little experience with Enterprise manager. A
> couple of days ago I downloaded SQL Compare and SQL Data compare.
>
> When using SQL Compare to copy a number of DB tables from a local SQL DB
to
> a remote SQL DB all appears to be OK except when I then examine the remote
> DB tables in Enterprise Manager I find that I have lost functionality on
> these tables, like the 'Design Table' option or delete option. I think
this
> may be something to do with permissions ?
>
> Am I right and how do I prevent this from happening ?
>
> I am considering purchasing the SQL Compare Bundle so would appreciate
> sorting this problem out,
>
> Kind Regards
>
> Lee BArrett
>
>
This discussion has been closed.