Users

Create a new user.

schema:gisq

Give the new user permission to connect and to create their own tables etc.

CREATE USER scott IDENTIFIED BY 'tiger'

Use operating system.

create user scott with password = 'tiger'
grant all on database scott to scott
grant access on database gisq to scott

CREATE USER scott IDENTIFIED BY 'tiger'

CREATE USER scott WITH PASSWORD 'tiger';
CREATE DATABASE scott;
GRANT ALL ON DATABASE scott to scott;

CREATE USER scott IDENTIFIED BY tiger
  TEMPORARY TABLESPACE temp
  DEFAULT TABLESPACE users;
GRANT CONNECT TO scott;
GRANT RESOURCE TO scott

CREATE LOGIN scott 
    WITH PASSWORD = 'tiger';
CREATE DATABASE scottsdb;
USE scottsdb;
CREATE USER scott FOR LOGIN scott;

--The foolowing doesn't work since 5.0
--INSERT INTO mysql.user (user, host, password)
--VALUES ('scott', 'localhost', PASSWORD('tiger'));

CREATE DATABASE scott;

GRANT SELECT, INSERT,UPDATE,DELETE,CREATE,DROP
   ON scott.* TO scott@localhost
   IDENTIFIED BY 'tiger';

FLUSH PRIVILEGES;

CREATE IDENT scott AS USER USING 'tiger';
CREATE DATABANK userBank;
GRANT TABLE ON userBank TO scott;

CREATE USER scott IDENTIFIED BY 'tiger'

Create a user from the operating system. Have that user run the command:

. /home/db2inst1/sqllib/db2profile

as part of the .bashrc (or whatever).

Access is a single user system. (Please email me if you know otherwise.)

If scott is the name of a Unix account there is no problem - otherwise you must insert the following line before the default lines

local scott template1 password

to the file /var/lib/postgres/data/pg_hba.conf this allows postgres user scott to connect to database template1.

You should specify the "tablespace" - if you don't it defaults to SYS which causes a whole world of pain. The CONNECT and RESOURCE grants permit users to connect to the system and to create stuff.

CREATE USER

Old Style: sp_addlogin 'scott', 'tiger'; CREATE DATABASE scott; USE scott;

sp_changedbowner scott

An IDENT is a user. A DATABANK corresponds to a file where the data is actually stored. Users normally have a SCHEMA - this is created as the user is created.

Users

Create a new user

Read tables from another schema/database

Change the default schema/database.

Find another process and kill it.

Set a timeout.

Change my own password

Who am I?