public inbox for [email protected]  
help / color / mirror / Atom feed
GRANT WITH INHERIT ??
2+ messages / 1 participants
[nested] [flat]

* GRANT WITH INHERIT ??
@ 2024-12-06 12:40  Arbol One <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Arbol One @ 2024-12-06 12:40 UTC (permalink / raw)
  To: pgsql-general

Hello.

When enter this commands in psql :

*sudo -u postgres psql
CREATE GROUP arbolone_dev_group; // Create a group
CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN GROUP 
arbolone_dev_group CREATEROLE;
GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;*

I get this error:
/ERROR:  syntax error at or near "INHERIT"
LINE 1: GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;/*/
/*

Is there something I missed?


-- 
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: GRANT WITH INHERIT ??
@ 2024-12-06 12:53  Arbol One <[email protected]>
  parent: Arbol One <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Arbol One @ 2024-12-06 12:53 UTC (permalink / raw)
  To: [email protected]

Resolved.
Thanks

On 2024-12-06 7:40 a.m., Arbol One wrote:
>
> When enter this commands in psql :
>
> *sudo -u postgres psql
> CREATE GROUP arbolone_dev_group; // Create a group
> CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN 
> GROUP arbolone_dev_group CREATEROLE;
> GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;*
>
> I get this error:
> /ERROR:  syntax error at or near "INHERIT"
> LINE 1: GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;/
>
-- 
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-12-06 12:53 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-12-06 12:40 GRANT WITH INHERIT ?? Arbol One <[email protected]>
2024-12-06 12:53 ` Arbol One <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox