• About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Disclaimer and copyright
Sql server Blog Forum

Helping SQL server DBAs and Developers

  • About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • 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 Kaliyamoorthy No Comments

Search box

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

Top Posts & Pages

  • The Cluster service failed to bring clustered service or application completely online or offline. One or more resources may be in a failed state.
    The Cluster service failed to bring clustered service or application completely online or offline. One or more resources may be in a failed state.
  • AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
    AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
  • Login failed for [SQLSTATE 28000] (Error 18456) the step failed
    Login failed for [SQLSTATE 28000] (Error 18456) the step failed
  • Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool 'internal' to run this query.
    Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool 'internal' to run this query.
  • TempDB database is Full and Optimization
    TempDB database is Full and Optimization
  • AlwaysON database not synchronizing suspect mode
    AlwaysON database not synchronizing suspect mode
  • Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
    Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
  • Microsoft SQL Server Migration plan and steps
    Microsoft SQL Server Migration plan and steps
  • Performance Tuning step by steps Series - SQL Main Part
    Performance Tuning step by steps Series - SQL Main Part
  • SQL server failed to start the system cannot find the path specified
    SQL server failed to start the system cannot find the path specified
Savona Theme by Optima Themes