ITPub博客

首页 > Linux操作系统 > Linux操作系统 > startup mount与startup restrict mount有何区别

startup mount与startup restrict mount有何区别

原创 Linux操作系统 作者:tolywang 时间:2007-10-13 00:00:00 0 删除 编辑
Restricting Access to a Database at Startup
You can start an instance and mount and open a database in restricted mode so that the database is available only to administrative personnel (not general database users). Use this mode of database startup when you need to accomplish one of the following tasks:

perform structure maintenance, such as rebuilding indexes

perform an export or import of database data

perform a data load (with SQL*Loader)

temporarily prevent typical users from using data

Typically, all users with the CREATE SESSION system privilege can connect to an open database. Opening a database in restricted mode allows database access only to users with both the CREATE SESSION and RESTRICTED SESSION system privilege; only database administrators should have the RESTRICTED SESSION system privilege.

Start an instance (and, optionally, mount and open the database) in restricted mode by using the STARTUP command with the RESTRICT option:

STARTUP RESTRICT;

Later, use the ALTER SYSTEM statement to disable the RESTRICTED SESSION feature.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84943/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 买新车省钱有5招
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13383031