SQL开发人员中创建新连接时出现问题 [英] problem when creating a new connection in SQL developer

问题描述

当我创建一个新连接时，我发现它包含与上一个连接相同的内容，即使我没有为该新连接编写任何内容.

when I created a new connection I find that it contains same content as the previous one, even I have not written anything to this new connection.

推荐答案

SQL Developer连接只是会话.如果您使用与现有连接用户相同的用户名，您将看到属于该架构的对象.

A SQL Developer connection is just a session. If you use the same username as an existing connection's user you will see the objects belonging to that schema.

如果您要创建新用户您实际上必须创建一个新用户.作为SYS(使用SYSDBA连接)和

If you want to create a new user you actually have to create a new user. Connect as SYS (using SYSDBA connection) and

create user new_user identified by some_password
default tablespace users;
grant create session, create table, create procedure to new_user;
grant quota 100M on users to new_user;

显然，给用户一个适合您需求的名称.授予它所需的所有特权. 了解更多.

Obviously give the user an appropriate name for your needs. Grant it all the privileges it needs. Find out more.

一旦创建了用户，就可以为其创建SQL Developer连接.

Once you have created the user you can create a SQL Developer connection for it.

这篇关于SQL开发人员中创建新连接时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！