Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


5
1
Sign in
to vote
Type: Suggestion
ID: 706766
Opened: 11/20/2011 10:55:34 PM
Access Restriction: Public
0
Workaround(s)
view

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.
Details
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
Sign in to post a workaround.