Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Richard Spitz — — source: Informix-list mailing list archive (1991-1998)
Steven Hauser (hause011@maroon.tc.umn.edu) wrote:
: How about a stored procedure owned by a user that has the rights to the
: 2nd database, the procedure can be called by any user on the first database
: and executes with the rights of the procedure owner.
Yes, but to execute the procedure, a user still needs CONNECT privilege
for the 2nd database. I want to avoid having to grant (and administrate)
any privileges for the 2nd database to the users of the 1st.
Regards, Richard
--
+----------------------------+-------------------------------------------+
| Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de |
| EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 |
| Klinikum Grosshadern | FAX : +49-89-7095-8886 |
| 81366 Munich, Germany | |
+----------------------------+-------------------------------------------+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.