We have an IDS 10 production database with hundreds of tables.
We created a new database for a read-only web application.
We created synonyms in the new database, pointing to the production
database, for the few tables that will be used in the web application.
And, we want to grant only select permissions to those synonyms for a
new "readonly" user.
We tried to grant select permissions to the synonym, and got:
556: Cannot create, drop, or modify an object that is external to
current database.
So we the granted the select permissions for the user in the original
tables, but no connect permission to the original database.
The problem is that when the user accesses the tables, he gets:
387: No connect permission.
111: ISAM error: no record found.
We don't want the user to connect to the productive database...
So, any ideas?
i guess the user needs to be able to logon.....
if that is not wanted you could set up ER or something or set up HDR
and have them connect to the readonly
secondary or???
Superboer.
I'll investigate to try to replicate only the few tables needed with
(sorry for the SQL Server slang, it the only db that I've replicated)
standard transactional replication (meaning the subscribers updates
won't replicate to the server).
Thank you all for your advice!
Manuel Daponte
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
>
> _________________________________________________________________
> Windows Live: Make it easier for your friends to see what you’re up to on Facebook.http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLM...- Hide quoted text -
>
> - Show quoted text -
In Spain he was "Zippy Cocopera"...
On Aug 25, 8:33 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: