NOCREATETABLE patch (was: Re: Please, help!(about P ostgres)) 
Author Message
 NOCREATETABLE patch (was: Re: Please, help!(about P ostgres))

That makes perfect sense to me. I was only going by what System
Privileges are granted to the Oracle roles of the same name. Oracle
has:

CONNECT -
ALTER SESSION  
CREATE CLUSTER  
CREATE DATABASE LINK    
CREATE SEQUENCE
CREATE SESSION  
CREATE SYNONYM  
CREATE TABLE    
CREATE VIEW    

RESOURCE -
CREATE CLUSTER  
CREATE PROCEDURE        
CREATE SEQUENCE
CREATE TABLE    
CREATE TRIGGER  

DBA -
All systems privileges WITH ADMIN OPTION        

But I agree with you. When I was first learning Oracle, I thought it
strange that the CONNECT role had anything more than CREATE/ALTER
SESSION privilege.

Mike Mascari

Quote:
-----Original Message-----

Sent:   Wednesday, May 09, 2001 3:20 AM

Cc:     Karel Zak; pgsql-hackers
Subject:        AW: [HACKERS] NOCREATETABLE patch (was: Re: Please,
help!(about P   ostgres))

> > The connect group would be granted these System Privileges:

If we keep it like others (e.g. Informix) this System Privilege would
be called
"resource". I like this name better, because it more describes the
detailed
priviledges.

> > CREATE AGGREGATE privilege
> > CREATE INDEX privilege
> > CREATE FUNCTION privilege
> > CREATE OPERATOR privilege
> > CREATE RULE privilege
> > CREATE SESSION privilege
> > CREATE SYNONYM privilege
> > CREATE TABLE privilege
> > CREATE TRIGGER privilege
> > CREATE TYPE privilege
> > CREATE VIEW privilege

The "connect" group would only have the priviledge to connect to the
db [and
create temp tables ?] and rights they where granted, or that were
granted to public.
They would not be allowed to create anything.

Andreas

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Sun, 26 Oct 2003 22:10:07 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. NOCREATETABLE patch (was: Re: Please, help!(about Postgres))

2. NOCREATETABLE patch (was: Re: Please, help!(about P

3. [PATCHES] Re: nocreatetable for 7.1.2 [patch]

4. nocreatetable for 7.1.2 [patch]

5. help me please, i am very lonely

6. Please Help - I am about to weep !!!

7. Please help, I am new to Jet Engine and SQL

8. what am I doing wrong? please help

9. Help Me please, I am a newbie

10. Please help, I am new here

11. please help, i am stuck with this last step~

12. Please Help!! I am Stuck


 
Powered by phpBB® Forum Software