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.
Jack Parker — — source: Informix-list mailing list archive (1991-1998)
At 09:59 AM 11/3/97 -0500, you wrote:
>I have two basic security questions about Informix:
>
>1. Is it true that if a user has execute permission on a stored proc,
>then the stored proc will be allowed to perform any table reads or
>updates (regardless of the original user's security profile). In other
>words, stored procedures are not "held back" by the initiating users'
>security level.
This is an advantage. A properly written stored procedure allows the user
to execute with the SPs authors permissions - even though they have none
themselves. This means you can lock them out from all of the tables and
force them to use the SP to manipulate them.
>
>2. Does Informix support specifying security down to the column level?
Yes. It's stored in syscolauth.
GRANT permission (column_list) ON table TO user_list
cheers
j.
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.