Set Oracle user expiry unlimted

-
ALTER PROFILE "DEFAULT" LIMIT
  SESSIONS_PER_USER UNLIMITED
  CPU_PER_SESSION UNLIMITED
  CPU_PER_CALL UNLIMITED
  CONNECT_TIME UNLIMITED
  IDLE_TIME UNLIMITED
  LOGICAL_READS_PER_SESSION UNLIMITED
  LOGICAL_READS_PER_CALL UNLIMITED
  COMPOSITE_LIMIT UNLIMITED
  PRIVATE_SGA UNLIMITED
  FAILED_LOGIN_ATTEMPTS 10
  PASSWORD_LIFE_TIME UNLIMITED
 PASSWORD_REUSE_TIME UNLIMITED
  PASSWORD_REUSE_MAX UNLIMITED
  PASSWORD_LOCK_TIME 1
  PASSWORD_GRACE_TIME 7
  PASSWORD_VERIFY_FUNCTION NULL;

to verify


column limit format a20

select profile,resource_name,limit from dba_profiles where profile='DEFAULT';

Comments

Post a Comment

Popular posts from this blog

Crypto Domains

-
Image
Building decentralized digital identities for the world Use blockchain domains as your: Universal username across apps and websites Website URL Payment address for wallets and much more! Register :  https://unstoppabledomains.com/r/mohinders To send cryptocurrency,  all you need to know is the recipient’s blockchain domain Send bitcoin, ethereum, and any other cryptocurrency  with just one domain No more worrying about sending to the wrong address Replace cryptocurrency addresses with a human readable name To send cryptocurrency,  all you need to know is the recipient’s blockchain domain Send bitcoin, ethereum, and any other cryptocurrency  with just one domain No more worrying about sending to the wrong address
Read more
-
IPFS powers the Distributed Web A peer-to-peer hypermedia protocol designed to preserve and grow humanity's knowledge by making the web upgradeable, resilient, and more open. The web of tomorrow needs IPFS today IPFS aims to surpass HTTP in order to build a better web for all of us. Today's web is inefficient and expensive HTTP downloads files from one server at a time — but peer-to-peer IPFS retrieves pieces from multiple nodes at once, enabling substantial bandwidth savings. With  up to 60% savings for video,  IPFS makes it possible to efficiently distribute high volumes of data without duplication. Today's web can't preserve humanity's history The average lifespan of a web page is 100 days  before it's gone forever. The medium of our era shouldn't be this fragile. IPFS makes it simple to set up resilient networks for mirroring data, and thanks to content addressing, files stored using IPFS are automatically versioned. Today's web is centralized, limit...
Read more