Обсуждение: 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 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