Difference between revisions of "Create a new user"

Revision as of 15:37, 23 July 2012

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;

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).

Create a new user

Read tables from another schema/database

@@ Line 34: / Line 34: @@
 CREATE USER scott FOR LOGIN scott;
 </source>
-<source lang='sql' class='def e-mysql'>--The foolowing doesn't work since 5.0
+<source lang='sql' class='def e-mysql'>
---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;
 </source>