Oracle SYS和SYSTEM帐户有什么区别? [英] What's the difference between the Oracle SYS and SYSTEM accounts?

问题描述

Oracle SYS和SYSTEM内置帐户之间有什么区别?

What are the differences between the Oracle SYS and SYSTEM built in accounts?

除了3个字母！

推荐答案

SYS拥有oracle数据字典.数据库中的每个对象(表，视图，包，过程等)都具有一个所有者.对于数据库字典，SYS用户拥有大量特殊表(性能视图等).

SYS owns the oracle data dictionary. Every object in the database (tables, views, packages, procedures, etc. ) all have a single owner. For the database dictionary, and a whole lot of special tables (performance views and the like) are all owned by the SYS user.

SYSTEM用户应该是具有所有这些对象访问权限的主DBA用户.这反映了Oracle长期以来的安全设计理念.您使用一个用户来构建应用程序，然后创建另一个具有访问权限(选择，更新，删除)但没有删除特权的用户.这为您提供了对模式的超级用户"访问权限，而又不会意外销毁它.多年来，已将某些内容添加到SYSTEM帐户中，而可能需要将其添加到SYS帐户中.但是，如果没有必要，很少有人愿意放弃对其SYS帐户的访问权限.

The SYSTEM user is supposed to be the master DBA user, with access to all of these object. This reflects an early, and long time, Oracle security design philosophy. You build the application using one user, then create a second with access (select, update, delete) but not drop privileges. This gives you a "super-user" access to your schema without being able to destroy it accidentally. Over the years, thing have been added to the SYSTEM account that may have needed to be in the SYS account. But very few people want to give out access to their SYS account if they don't have to.

这篇关于Oracle SYS和SYSTEM帐户有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！