I have 2 data dictionaries "src" and dest"

in dest is a stored procedure that copies table ontents ( insert into mytable select xyz from "src.add".othertable )

user hello has execute, alter, update on the stored procedure. User hello does not exist in src or does not have rights specified on othertable

When I run the stored procedure as adssys - all is fine

as user hello, I am getting 7079 errors.

I thought, once a user has execute rights on the stored procedure, not further rights checking is performed. Is that not the case for a query across dictionaries? Any hints?

Thanks Oskar

asked 16 Jan '15, 08:53

Oskar's gravatar image

Oskar
841404366
accept rate: 18%


Hi

Whenever a stored procedure returns a result set, only field values with read access are returned. There are 3 different levels:

  • read and write (select, update and insert)
  • read only for sql where condition, NULL is returned
  • no acces at all, NULL is returned.

So even if a user has rights to execute the procedure, he still needs rights to read the table and fields, no matter if linked add or not.

Marcus

link

answered 19 Jan '15, 11:21

Marcus%20Herz's gravatar image

Marcus Herz
581192235
accept rate: 19%

edited 19 Jan '15, 11:23

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×40

Asked: 16 Jan '15, 08:53

Seen: 1,354 times

Last updated: 19 Jan '15, 11:23

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.