What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 128 Stack Exchange communities.

Is there any documentation on what is/isn't permitted on data.SE?

Specifically can I create:

  • views
  • temp-tables
  • procedures
  • functions

Do I have my own schema to play with?

share|improve this question
1  
For those looking for schema documentation please refer to meta.stackexchange.com/a/2678/166536 –  Merlin Jul 25 '12 at 12:36
add comment

1 Answer 1

up vote 4 down vote accepted

You're pretty much permitted to do anything that the system allows you to execute*. With that in mind, the database user used to execute user queries has the following set of permissions for any given site's database:

  • CONNECT
  • SHOWPLAN
  • SELECT

Excluding the operations from your list that require additional permissions leaves you with the ability to create temporary tables, since any user can do that.

Do I have my own schema to play with?

No, you're running queries against the same schema in use by all other users of the system.

* Though running intentionally abusive queries (i.e. ones that make the server sad-face) is grounds for being banned, of course

share|improve this answer
1  
Thanks Tim :) I will definitely avoid any server sad-face action. –  Merlin Jul 14 '12 at 22:12
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .