如何在 Oracle SQL Developer 中创建用户
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13791434/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to create a user in Oracle SQL developer
提问by Ruba Mushtaq
I am newbie to oracle sql developer 3.1.07.42, and have just installed it on my machine. I want to make a new connection, but it requires a user and a password which I do not know. I have been googling about it since many days, and have learned that there are some commands to create user, but I do not know where should I run those commands, because I cannot run queries/commands until the connection is created. Would anyone let me know what should I do?
我是 oracle sql developer 3.1.07.42 的新手，刚刚在我的机器上安装了它。我想建立一个新的连接，但它需要一个我不知道的用户和密码。很多天以来我一直在搜索它，并了解到有一些命令可以创建用户，但我不知道应该在哪里运行这些命令，因为在创建连接之前我无法运行查询/命令。有没有人让我知道我该怎么办？
回答by MKMohanty
Steps for creating new user :
创建新用户的步骤：
1)Open Sql Developer, make new connection.
1）打开Sql Developer，建立新的连接。
2)Login with System username and password(made during installation).
2) 使用系统用户名和密码（在安装过程中创建）登录。
3)Once you connect, Right click users and add new user.
3）连接后，右键单击用户并添加新用户。
4)Give its username and password & select appropriate system privilege.
4）提供其用户名和密码并选择适当的系统权限。
5)You are done now, check by making new connection.
5）您现在完成了，通过建立新连接进行检查。
回答by Bhaskara Arani
Use this below simple commands to create an user
使用以下简单命令创建用户
-- Create a user
CREATE USER youruser IDENTIFIED BY yourpassword;
--Grant permissions
GRANT CONNECT, RESOURCE, DBA TO demo;
回答by mrnaza
you should install database software in your local pc/laptop then create user in the database and you can connect the database via sql developer by key in username and password that already created.If you want to connect to other database same step like the previous step but before that you need to point to the remote database.
你应该在你的本地电脑/笔记本电脑上安装数据库软件，然后在数据库中创建用户，你可以通过 sql developer 通过键入已经创建的用户名和密码连接数据库。如果你想连接到其他数据库与上一步相同的步骤但在此之前，您需要指向远程数据库。
回答by Sina Zeinali
I thinks you should use "Database Configuration Assistant" to create new database and U can set user name and password and use it in oracle SQL Developer!!!
我认为你应该使用“数据库配置助手”创建新数据库，你可以设置用户名和密码并在oracle SQL Developer中使用它！！！
