R
RTL
Hello all,
I have a problem which may just be a config problem. I have linked tables to
a SQL DB view. For all users, it just has INSERT permissions to this
table--except one. This particular user has SELECT permissions among others.
However, when he goes to view the table, it comes back as "#deleted" It's
baffling to me. You can view the data in the Enterprise Manager without
issue--so the data is getting there.
We have deleted the links/relinked...tried new databases--nothing.
We have other SQL databases in the same SQL Server 2000 and can view the
data without trouble. It's just this one and I cannot find the differences.
I am baffled.
Thanks for any advice,
Rich
www.techarts.com
I have a problem which may just be a config problem. I have linked tables to
a SQL DB view. For all users, it just has INSERT permissions to this
table--except one. This particular user has SELECT permissions among others.
However, when he goes to view the table, it comes back as "#deleted" It's
baffling to me. You can view the data in the Enterprise Manager without
issue--so the data is getting there.
We have deleted the links/relinked...tried new databases--nothing.
We have other SQL databases in the same SQL Server 2000 and can view the
data without trouble. It's just this one and I cannot find the differences.
I am baffled.
Thanks for any advice,
Rich
www.techarts.com