DBA Hub

📋Steps in this guide1/1

Create user profile - EDB Postgres

--- in edb postgres advanced server we can create user profile ---- similar to that of oracle.

postgresql configurationintermediate
by PostgreSQL
10 views
1

Create user profile - EDB Postgres

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
--- in edb postgres advanced server we can create user profile
---- similar to that of oracle.
-- Create profile:
#
create profile REPORTING_PROFILE limit FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LIFE_TIME 90;
--- Alter profile:
#
alter profile REPORTING_PROFILE limit FAILED_LOGIN_ATTEMPTS 1;
-- view profile details:
#
select * from dba_profiles;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!