A Gentle Introduction to

SQL

USERS

How to create users, give them access, get at other peoples tables. How to find processes and kill them.


Set a timeout.
Users may accidentally (or deliberately) start queries which would take a very long time to complete. We can set a 'timeout'; this means that the system gives up after a certain amount of time.
oracle variations:
The user scott is limited to 1 minute per connection. After this time he will be logged out, if he is running a query it will be abandoned.

access
db2
mysql
oracle
postgres
sqlserver