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.


Read tables from another schema/database
A particular server may support a number of different sets of tables. In Oracle these are schemas in MySQL they are databases. In both cases each user normally has their own set of tables, other users tables may be accessed using a dot notation.
oracle variations:
haggis is another user with a table called tat.

access
db2
mysql
oracle
postgres
sqlserver