User Code List
SQL
---Recreate Caliburn
---Recreate pakis in dev-server2
---Customize servers
---Kill an oracle session
---New Snippet
---New Snippet
---New Snippet
---Reset replication
------New Snippet
---Reset current instance
JRuby
---Instance user
---Run test
---Receive replication messages
------New Snippet
---Send replication
---Replication unit scripts
New Snippet
PostgreSQL
---Create drop users
 
 
Create drop users
 

DROP DATABASE PAKI1;

DROP DATABASE PAKI2;

DROP DATABASE PAKI3;

DROP DATABASE PAKI4;

DROP DATABASE PAKICONT1;

DROP DATABASE PAKICONT2;

DROP DATABASE PAKICONT3;

DROP DATABASE PAKICONT4;

CREATE DATABASE PAKI1

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE paki1 TO public;

GRANT ALL ON DATABASE PAKI1 TO postgres;

GRANT ALL ON DATABASE PAKI1 TO caliburn;

CREATE DATABASE PAKI2

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKI2 TO public;

GRANT ALL ON DATABASE PAKI2 TO postgres;

GRANT ALL ON DATABASE PAKI2 TO caliburn;

CREATE DATABASE PAKI3

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKI3 TO public;

GRANT ALL ON DATABASE PAKI3 TO postgres;

GRANT ALL ON DATABASE PAKI3 TO caliburn;

CREATE DATABASE PAKI4

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKI4 TO public;

GRANT ALL ON DATABASE PAKI4 TO postgres;

GRANT ALL ON DATABASE PAKI4 TO caliburn;

CREATE DATABASE PAKICONT1

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKICONT1 TO public;

GRANT ALL ON DATABASE PAKICONT1 TO postgres;

GRANT ALL ON DATABASE PAKICONT1 TO caliburn;

CREATE DATABASE PAKICONT2

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKICONT2 TO public;

GRANT ALL ON DATABASE PAKICONT2 TO postgres;

GRANT ALL ON DATABASE PAKICONT2 TO caliburn;

CREATE DATABASE PAKICONT3

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKICONT3 TO public;

GRANT ALL ON DATABASE PAKICONT3 TO postgres;

GRANT ALL ON DATABASE PAKICONT3 TO caliburn;

CREATE DATABASE PAKICONT4

WITH OWNER = postgres

ENCODING = 'UTF8'

CONNECTION LIMIT = -1;

GRANT CONNECT, TEMPORARY ON DATABASE PAKICONT4 TO public;

GRANT ALL ON DATABASE PAKICONT4 TO postgres;

GRANT ALL ON DATABASE PAKICONT4 TO caliburn;
 
Sub-Article List