Skip to content
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
SQL Server Blog Forum

Guide to SQL Server DBAs and Developers

  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • Oracle

    Oracle User Profile Profile (password & session) Role (object & system) User-09

    January 8, 2016

    Profile {Profile (password & session), Role (object & system), User} Profile — is for resource limit, we can enforce password & session parameters to the user Role — is for system & object level permission for user   Profile It’s a collection of user security resource limit. We can apply password and session parameters. You can enforce a limit on resource utilization using resource limit parameters. Also, you can maintain database security by using password management feature. User accounts can have only a single profile. By default a DEFAULT profile will be assigned for the user.   Types: 1. Password management 2. Session management Password management parameters: Default for all…

    Read More
    Muthukkumaran No Comments

Search Box

Advertisements

Categories

  • AlwaysON
  • AutoMon
  • Azure
  • Backup/Restore
  • Basics for freshers
  • DBA
  • Docker
  • DR/HA
  • Indexes
  • Internals
  • Junior DBA
  • Microsoft
  • Oracle
  • Performance
  • PowerShell
  • Questions
  • Scripts
  • SQL party
  • T-SQL
  • VLDB

Archives

Top SQL server blogs

  • Adam Machanic
  • Amit Banerjee
  • Brent Ozar
  • Gail Shaw
  • Grant Fritchey
  • Paul White
  • Pinal Dave
  • SimpleTalk
  • Sqlblog
  • SQLskills
Powered by RAR Web Solutions