Books Online: Suggested permission to create Spatial Index incorrect - by crazyv

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


5
1
Sign in
to vote
ID 706766 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 11/20/2011 10:55:34 PM
Access Restriction Public

Description

Books online link: http://technet.microsoft.com/en-us/library/bb934196.aspx

Page title: CREATE SPATIAL INDEX (Transact-SQL)

Under sub-header "Permissions" states: 
"Requires ALTER permission on the table or view. User must be a member of the sysadmin fixed server role or the db_ddladmin and db_owner fixed database roles."

The article suggests that a login with "sysadmin" or "db_ddladmin" and "db_owner" roles are allowed to create a spatial index.

However, I find that ALTER permission on the table object alone will allow creating a spatial index on a table.
Sign in to post a comment.
Posted by Microsoft on 11/28/2011 at 8:57 AM
crazyv, Thank you for pointing this out. Based on similar topics, I think the intention was: "The user must have ALTER permission on the table or view, OR be a member of the sysadmin fixed server role or the db_ddladmin and db_owner fixed database roles." I have fixed the topic. Thank you for taking the time to report this misleading statement. -Doug