Redian新闻
>
各位老大,管理数据库的用户,这样行吗?
avatar
各位老大,管理数据库的用户,这样行吗?# Database - 数据库
b*n
1
Hello all,
I am learning Oracle RDBMS and am confused with the admin of it.
I have a user named APPADMIN which is to be used to administrate the schema
for the application and hence has the privelege to create tables, drop tables
and etc. meanwhile, the application used by the users need to access the
database with a more restrictive previliges. and my application may have lots
of users to use it.
my 1st question is: how to manage the so many application users? i should
create all the app users
avatar
c*d
2
for first question, either way can do the job, kind of trade off thing.
second question, do not get what u mean.

tables
lots
application?
APPADMIN.

【在 b***n 的大作中提到】
: Hello all,
: I am learning Oracle RDBMS and am confused with the admin of it.
: I have a user named APPADMIN which is to be used to administrate the schema
: for the application and hence has the privelege to create tables, drop tables
: and etc. meanwhile, the application used by the users need to access the
: database with a more restrictive previliges. and my application may have lots
: of users to use it.
: my 1st question is: how to manage the so many application users? i should
: create all the app users

avatar
b*n
3
I am using Oracle as the DB server. so i create a user APPADMIN to create and
maintain the schema objects (tables, views, and etc). When i access the
database with an application user, say TOM, who is another database user in
the Oracle, I need to use a SQL as "SELECT * from APPADMIN.sometable". that
looks very inconvenient, as I have to use the schema name before the table
names, and it is not portable to other DBMS. on the other hand, if i use
APPADMIN to connect to the database in the applic

【在 c***d 的大作中提到】
: for first question, either way can do the job, kind of trade off thing.
: second question, do not get what u mean.
:
: tables
: lots
: application?
: APPADMIN.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。