granular permissions required to see execution plans

[Former Member]

Hi,

we have recently started working with Sybase ASE.

We want to provide access to execution plans for different queries.

However we dont want to grant the users with sa_role or make them owners of the database.

Is there another way to do this? I believe we could switch on some granular permissions to do this but I'm not sure which ones would give us that capability.

Can someone tell me which permission we should grant?

Thanks In Advance

David

[Former Member]

Hi Mark,

the version is 15.7 as shown below:

We have a set of users who want to access all the query plans:

How would the users be accessing query plans?

-- I'm assuming using sp_showplan to do this

- looking for query plans for their own queries?

--Yes, as well as other users

- looking for query plans of other users and/or spids?

--Yes

- looking for historical query plans (as opposed to plans of currently running queries)?

--Looking for both historical and current query plans

- some other variation?

I will look at the source code for sp_showplan to see if we can grant this to public.

Regards

David