TOAD用SYSDBA登陆后给NORMAL授权

1.打开TOAD【帮助】文档(F1):
2.索引选项卡中输入：granting
3.选择granting分支：team Coding Roles
4.在出现的标题为：Grant Team Coding Roles to Users下面有整个过程

Grant Team Coding Roles to users in the same way you would grant other roles.

Note: You must be connected as a DBA user to grant roles.

You can grant roles from the Schema Browser, Users page.

To grant roles to users

Select a user in the left panel

Click the Alter User button.

Click the Roles tab. Add or remove roles as desired.

You can also grant roles from the SQL Editor. Enter the appropriate SQL and execute it. For example:

grant TC_ADMIN_ROLE to ARTHUR

grant TC_LDR_ROLE to SUSAN

5.大意就是：TOAD新建连接中，以DBA身份登陆，连接类型选择SYSDBA，
登陆后，在【数据库】->【架构浏览】->左侧框中出现选项卡（如这个样子的< >），
点击">",大致找到第11个就是Users，
然后选中下方列表框中要授权的用户名，
右键点击选中的用户名，选择Alter(或者列表上方带有Alter提示的图标)
选择选项卡中的【System privileges】，然后就是添加权限，connect一定是必须的，
确定退出再用Normal身份登陆就可以了。