Profile Creation

On 10/2/20 1:40 PM, Brajendra Pratap Singh wrote:

Hi All,

How can we create a user profile in open postgresql db?

You are going to need to be more specific about what you consider a user
profile to be.

Thanks,
Singh

--
Adrian Klaver
adrian.klaver@aklaver.com

On Fri, Oct 2, 2020 at 1:43 PM Brajendra Pratap Singh <
singh.bpratap766@gmail.com> wrote:

How can we create a user profile in open postgresql db?

?

CREATE TABLE user_profile (...);
INSERT INTO user_profile VALUES (...);

David J.

Hi Adrian,

Here the user profile means which contains the following functionality same
as in EDB profile contains like password_verify_function,
password_life_time, password_lock_time etc.

Thanks,
Singh

On Sat, 3 Oct, 2020, 2:14 AM Adrian Klaver, <adrian.klaver@aklaver.com>
wrote:

On 10/2/20 2:45 PM, David G. Johnston wrote:

On Fri, Oct 2, 2020 at 1:43 PM Brajendra Pratap Singh
<singh.bpratap766@gmail.com <mailto:singh.bpratap766@gmail.com>> wrote:

How can we create a user profile in open postgresql db?

?

CREATE TABLE user_profile (...);
INSERT INTO user_profile VALUES (...);

David J.

I'm betting on
CREATE ROLE rolename WITH option

https://www.postgresql.org/docs/13/sql-createrole.html

On 10/2/20 1:56 PM, Brajendra Pratap Singh wrote:

Hi Adrian,

Here the user profile means which contains the following functionality
same as in  EDB profile contains like password_verify_function,
password_life_time, password_lock_time etc.

The below then?:

https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/database-compatibility-for-oracle-developers-guide/9.5/Database_Compatibility_for_Oracle_Developers_Guide.1.073.html

If that is the case, there is no built in mechanism for that in the
community edition. It would need to be built by you.

Thanks,
Singh

On Sat, 3 Oct, 2020, 2:14 AM Adrian Klaver, <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 10/2/20 1:40 PM, Brajendra Pratap Singh wrote:

Hi All,

How can we create a user profile in open postgresql db?

You are going to need to be more specific about what you consider a
user
profile to be.

Thanks,
Singh

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com