![]() |
What is the difference between EXECUTE and EXECUTE PROCEDURE permission? What is the difference between EXECUTE and EXECUTE FUNCTION permission?
24 Nov 2014
| 2 comments
,
|
![]() |
Hi everyone!
01 Apr 2014
,
|
![]() |
developers in my shop want permission to Create Objects in Production because they say they need to Collect Statistics and drop/recreate indexes but i find that they end up creating many 'backup' tables that take up valuable prod space. how is this handled in other shops?
05 Feb 2014
| 3 comments
,
|
![]() |
Hi Masters, I have some questions on how user access works with respect to object and database level We have a database where all reporting views are residing. All users were granted Select access at the database level (through role or explicit grant) so they can query any view residing in this database. Now we want to revoke access on a particular view but still let them have access to rest of the views. Below are my questions
11 Jan 2012
| 3 comments
,
|
![]() |
Is there a permission that will allow a particular user (ME) to execute an EXPLAIN of Sql that updates or inserts into tables or selects from tables that I don't have update or insert or select permissions on? (or creates a table in a database that the "Explaining user" doesn't have permission to)?
05 Oct 2011
| 5 comments
,
|
![]() |
So you have Viewpoint installed and you are logged in for the first time, a blank Viewpoint pane stares back at you ... Now what?
29 Apr 2010
| 16 comments
,
|