Re: [GENERAL] Understanding database schemas

2013-08-02 Thread Melvin Call
On Fri, Aug 2, 2013 at 1:36 PM, Bosco Rama wrote: > On 08/02/13 10:56, Melvin Call wrote: > > > > If I may pigtail another related question, what is the procedure for > > allowing another user access to that schema? > > Heh. You almost have the words already: >grant usage on schema hrschema

Re: [GENERAL] Understanding database schemas

2013-08-02 Thread Bosco Rama
On 08/02/13 10:56, Melvin Call wrote: > > If I may pigtail another related question, what is the procedure for > allowing another user access to that schema? Heh. You almost have the words already: grant usage on schema hrschema to hr_user; This will allow them to see the objects in the sche

Re: [GENERAL] Understanding database schemas

2013-08-02 Thread Melvin Call
On Fri, Aug 2, 2013 at 12:56 PM, Melvin Call wrote: > On Fri, Aug 2, 2013 at 11:56 AM, Bosco Rama wrote: > >> On 08/02/13 09:33, Melvin Call wrote: >> > >> > $ psql -U postgres >> > >> > DROP SCHEMA IF EXISTS hrschema CASCADE; >> > DROP DATABASE IF EXISTS personnel; >> > DROP USER IF EXISTS hr_adm

Re: [GENERAL] Understanding database schemas

2013-08-02 Thread Melvin Call
On Fri, Aug 2, 2013 at 11:56 AM, Bosco Rama wrote: > On 08/02/13 09:33, Melvin Call wrote: > > > > $ psql -U postgres > > > > DROP SCHEMA IF EXISTS hrschema CASCADE; > > DROP DATABASE IF EXISTS personnel; > > DROP USER IF EXISTS hr_admin; > > > > CREATE USER hr_admin > >WITH CREATEDB > >P

Re: [GENERAL] Understanding database schemas

2013-08-02 Thread Bosco Rama
On 08/02/13 09:33, Melvin Call wrote: > > $ psql -U postgres > > DROP SCHEMA IF EXISTS hrschema CASCADE; > DROP DATABASE IF EXISTS personnel; > DROP USER IF EXISTS hr_admin; > > CREATE USER hr_admin >WITH CREATEDB >PASSWORD 'md5be394806d6a21c6c52aa2b76063c7d9d'; > > DROP DATABASE IF EXI