Re: How Restricting user

[Daniel Gallo <danielito.gallo@xxxxxxxxx>]

thanks a lot David!!!!

2016-02-25 15:08 GMT-03:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Thu, Feb 25, 2016 at 11:01 AM, dangal <danielito.gallo@xxxxxxxxx> wrote:

In Oracle i have something  like this:

-- Create profile
create profile PROFILE_Query limit
  sessions_per_user 25
  cpu_per_call 30000
  connect_time 120
  idle_time 20
  logical_reads_per_session 80000
  logical_reads_per_call 25000;

-- Add users to profile
alter user XXX profile PROFILE_Query ;

I cant find something like this in postgres

​It doesn't exist in PostgreSQL.

David J.

​