Permission Problems
Brian Donahue
Posts: 6,590 Bronze 1
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" <lee.home@eupa.co.uk> wrote in message
news:xxpWy8jJEHA.1236@server53...
> 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
>
>
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" <lee.home@eupa.co.uk> wrote in message
news:xxpWy8jJEHA.1236@server53...
> 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.
