- 浏览: 16094 次
- 性别:
- 来自: 成都
最新评论
1.profile
1>.failed_login_attempts
2>.password_lock_time
3>.password_lift_time
4>.password_grace_time
5>.password_reuse_time
6>.password_reuse_max
7>.password_verify_function
8>.cpu_per_session
9>.session_per_user
10>.connect_time
11>.idle_time
12>.logical_reads_pre_session
13>.private_sga
14>.cpu_per_call
15>.logical_reads_per_calls
Hints:oracle默认的密码验证函数veryfy_function
2.常用操作
1>.删除profile
2>.启动资源生效功能
3>.主要的包
dbms_resoure_manager
3.重要的视图
dba_users,dba_profiles
1>.failed_login_attempts
2>.password_lock_time
3>.password_lift_time
4>.password_grace_time
5>.password_reuse_time
6>.password_reuse_max
7>.password_verify_function
8>.cpu_per_session
9>.session_per_user
10>.connect_time
11>.idle_time
12>.logical_reads_pre_session
13>.private_sga
14>.cpu_per_call
15>.logical_reads_per_calls
Hints:oracle默认的密码验证函数veryfy_function
2.常用操作
1>.删除profile
drop profile profilename cascade
2>.启动资源生效功能
alter system set resoure_limit = true scop=spfile
3>.主要的包
dbms_resoure_manager
3.重要的视图
dba_users,dba_profiles
发表评论
-
Orale Auditing
2010-12-26 12:12 6141. 记录方式session/access 2. 标准审计 s ... -
管理权限
2010-12-26 10:49 6311.显示当前用户拥有的权限 select * from ses ... -
Oracle logBuffer
2010-12-16 18:05 687各地现场的log_buffer都不一样,有的现场设置为200M ... -
Index Management
2010-12-12 11:11 7541.classification of indexex ... -
Table Management
2010-12-12 08:34 6791.temporay table语法 a>:基于事 ... -
Undo Management
2010-12-11 10:53 6751.undo 表空间大小的确定 ... -
基于时间点的不完全恢复
2010-12-08 18:43 1536Hints: The requirements for dat ... -
oracle 热备份
2010-12-08 17:29 631SQL> set time on; 17:25 ... -
Oracle 冷备份
2010-12-07 11:34 536SQL> select count(*) fro ... -
Storage structure & Relationship
2010-12-05 09:35 7251.目标 a.描述数据库的逻辑结构 b.列出segment的类 ... -
Oracle 维护小技巧
2010-12-04 11:55 6021.重新编译有错误的函数,存储过程,包 select 'A ... -
oracle 性能监控常用SQL
2010-12-03 18:44 727监控数据库性能的SQL 查看tablespace的空間 ... -
Oracle正则表达式
2010-12-03 18:07 830Oracle 10g数据库内建了符合IEEE POSIX (P ... -
oracle 记录,嵌套表,集合
2010-12-03 11:39 16081.exists 检查集合中是否存在某个元素,collecti ... -
oracle 关联数组,bulk collect,forAll,动态SQL
2010-12-02 18:22 20171.今天花了点时间看了下plsql的关联数组,可谓是几经波折啊 ... -
手动创建数据库
2010-12-02 09:12 678[b]1.操作指南(摘自oracle在线帮助文档) Step ... -
Tablespaces&Datafiles
2010-12-01 21:32 659a.目标 1.定义表空间和数据文件,熟悉相关的脚本参数 2.创 ... -
Redo Log File
2010-11-30 21:00 799a.日志文件概要 1.Record all changes m ...
相关推荐
create user username identified by password default tablespace user_data temporary tablespace user_temp; /*第4步:给用户授予权限 */ grant connect,resource,dba to username; ----------...
Create a "change management" system with Advanced Group Policy Management (AGPM v4) Understand Windows Intune service and its relationship to Group Policy Coverage Includes: Updated GPMC New Windows 8...
* 22 Resource Usage And Limitation * 23 Non-Local Exits * 24 Signal Handling * 25 The Basic Program/System Interface * 26 Processes * 27 Job Control * 28 System Databases and Name Service ...
The original picture resource management library can quickly and conveniently manage the pictures needed in the program. The unique image resource attribute supports the direct use of the detailed ...
create user user_name identified by password 创建用户 alter user system identified by manager;修改用户密码 grant dba to user_name 用户授权 drop user user_name cascade 清空指定用户的所有数据,但...
Change Password 190 Commit & Rollback 190 Connect and Disconnect 191 DBMS_Flashback 191 Diagnosing Problems 193 View Extents 193 Identify Space Deficits 193 Log Switch Frequency Map 194 Tablespace Map...
Covers creating zones and resource records, modifying DNS server configuration, querying DNS, and customizing the resource records a domain controller dynamically registers. Chapter 14, Security and ...
Connecting to the Database Without a Password Installing and Configuring SQL*Net Setting Up Initialization Parameters for Security Chapter 9 Developing a Simple Security Application The ...
Introducing the PasswordGenerator Console Application 537 Interacting with the User 537 Handling Command-Line Input 539 Adding Color and Positioning to Consoles 540 Summary 543 25 Writing ...
使用Cloudwatch命名空间作为Resource/RabbitMQ RabbitMQ监视。 每个度量标准都具有队列名称,并具有其现有消息计数的数量。 名为TotalMessages的特殊度量标准,用于度量所有队列中的消息总数。 设置环境变量 RABBIT...
appkernel-API开发变得容易 什么是Appkernel? 超级易用的API框架,可在几分钟之内(从零开始,数分钟之内)使API创建从零到生产。 它提供了开箱即用的数据序列化,转换,验证,安全性,ORM,RPC... password = Prop
:waving_hand: terraform { required_providers { lastpass = { source = " nrkno/lastpass " } }}resource " lastpass_secret " " mysecret " { name = " My site " username = " foobar " password = file ( " ${
Changing Your Password...................................................................................................51 Setting Profile and Spreadsheet Data Options...................................
The main resource in the FreeBSD community is its developers: the committers and contributors. It is with their contributions that the project can move forward. Regular developers are referred to as ...
RESOURCE:拥有Resource权限的用户只可以创建实体,不可以创建数据库结构。 CONNECT:拥有Connect权限的用户只可以登录Oracle,不可以创建实体,不可以创建数据库结构。 注意: 对于普通用户:授予connect, ...
.\Samples\delphi\BroswerDemo\Resources Resource file, web pages and movie linked into browser demo .\Samples\delphi\FtpDemos Delphi Win32/Win64 FTP sample applications (all Delphi versions) .\Samples\...
Performance and resource usage PEP 397: Python Launcher for Windows PEP 3151: Reworking the OS and IO exception hierarchy PEP 380: Syntax for Delegating to a Subgenerator PEP 409: Suppressing ...
切换到“执行流”界面,添加“Sign-On Password”和“Sign-On User Name”两个测试用例: 右键选择“Sign-On User Name”,选择“测试运行计划” 新建执行条件: 设置“Sign-On User Name”的时间...
Oracle9i初始化参数中文说明 Blank_trimming: 说明: 如果值为TRUE, 即使源长度比目标长度 (SQL92 兼容) 更长, 也允许分配数据。 值范围: TRUE | FALSE 默认值: FALSE serializable: 说明: 确定查询是否获取表级...
Table of Contents Preface, Notes, Licenses . . . . . . . . ....1. Licenses for Third-Party Components ....1.1. FindGTest.cmake License ....1.2. LPeg Library License ....1.3. LuaFileSystem Library License ....