[Gusdev-gusdev] DBA stuff

[pjm <pj...@sa...>]

Deborah,

our head DBA, Martin Widlake, has written a script (see below) that may need to
go into CVS. It created the six users for the six schemas. Also this quote from
Martin;

"I checked the view creation scripts and it looks like that for each view the
owner is stated but the owner of the table it is on is not. However, in every
case the table belongs to the same schema and no other schema will have that
table in it, so is should work fine."

Might be worth specifying the schemas?

I am about to run the table creation scripts and will let you know how I get on.
I have changed USER3 to be &1 so it can fit in with our stuff easily.

Paul.

-- cre_gus_new_users.sql
-- create the users needed for GUS30
-- Needs to be run from a suer which has create user system priv
-- (Run from a user with DBA role!)
--
drop user core cascade;
drop user corever cascade;
drop user dots cascade;
drop user dotsver cascade;
drop user sres cascade;
drop user sresver cascade;
--
set echo on
spool cre_gus_new_users.lst
create user core identified by core
temporary tablespace temp_01
default tablespace users
/
grant connect to core;
grant resource to core;
--
create user corever identified by corever
temporary tablespace temp_01
default tablespace users
/
grant connect to corever;
grant resource to corever;
--
create user dots identified by dots
temporary tablespace temp_01
default tablespace users
/
grant connect to dots;
grant resource to dots;
--
create user dotsver identified by dotsver
temporary tablespace temp_01
default tablespace users
/
grant connect to dotsver;
grant resource to dotsver;
--
create user sres identified by sres
temporary tablespace temp_01
default tablespace users
/
grant connect to sres;
grant resource to sres;
--
create user sresver identified by sresver
temporary tablespace temp_01
default tablespace users
/
grant connect to sresver;
grant resource to sresver;
spool off
set echo off
--