Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
js.reddy
Yak Posting Veteran
80 Posts |
 Posted - 2008-05-05 : 00:30:21
|
| Hi How can I provide SHOWPLAN permission.Regards,Reddy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-05 : 01:22:41
|
SHOWPLAN_ALL permissions taken directly from SQL Server Books Online:quote:
In order to use SET SHOWPLAN_ALL, you must have sufficient permissions to execute the statements on which SET SHOWPLAN_ALL is executed, and you must have SHOWPLAN permission for all databases containing referenced objects.For SELECT, INSERT, UPDATE, DELETE, EXEC stored_procedure, and EXEC user_defined_function statements, to produce a Showplan the user must:Have the appropriate permissions to execute the Transact-SQL statements.Have SHOWPLAN permission on all databases containing objects referenced by the Transact-SQL statements, such as tables, views, and so on.For all other statements, such as DDL, USE database_name, SET, DECLARE, dynamic SQL, and so on, only the appropriate permissions to execute the Transact-SQL statements are needed.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-05 : 14:34:19
|
To grant SHOWPLAN permission to a non-dbo user, you can use:grant showplan to USER/ROLE |
|
|
|
jwalantsoneji
Starting Member
2 Posts |
Posted - 2011-06-13 : 14:36:43
|
| In what all database roles, SHOWPLAN permissions are granted by default?------------------------Jwalant N. Soneji(BE IT) India------------------------ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SHOWPLAN permission