如果你的远程桌面没有授权的话，Licensing有限期只有120天。所以在你要连服务器的客户机上把Licensing删除。打开注册表删除以下文件HKEY_LOCAL_MACHINE\Software\Microsoft\MSLicensing

EXEC sp_addrolemember N'db_owner', N'db'----将db 设置为 db_owner 角色中的一员
EXEC sp_droprolemember N'db_owner', N'db'----将db 从 db_owner 角色 去除
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO dbs  ----给db 赋予 拥有 db_datareader 架构
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO db --- 修改 db_datareader 架构的所有者为db
ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [db_datareader]   ---修改 db_datareader 角色所拥有的架构
 
--- 赋予 《授予 XX 权限》
GRANT VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db]  --查看
GRANT ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db]     --修改
GRANT TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db]   --接管所有权
GRANT CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db]    --控制权
GRANT EXECUTE ON dbo.[PSYP_DataBaseBackUp] TO db     --执行
 
---赋予  《具有授予XX权限》
---如果直接给  具有授予权限 则 默认给予了XX权限
GRANT VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION --- --查看权限并具有授予权限
GRANT ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
GRANT TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
GRANT CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
GRANT EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
 
----拒绝XX权限
DENY VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
DENY ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
DENY TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
DENY CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
DENY EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
 
---收回XX权限
REVOKE VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db]  ---查看定义
REVOKE ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db]     --修改
REVOKE TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db]   --接管所有权
REVOKE CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db]    --控制权
REVOKE EXECUTE ON dbo.[PSYP_DataBaseBackUp] TO db     --执行
 
---收回XX具有授予权限
REVOKE GRANT OPTION FOR VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
REVOKE GRANT OPTION FOR ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
REVOKE GRANT OPTION FOR TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
REVOKE GRANT OPTION FOR CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
REVOKE GRANT OPTION FOR EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
 
--------给表赋 权限
--- 赋予  《具有授予XX权限》
GRANT INSERT ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT VIEW DEFINITION ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT VIEW CHANGE TRACKING ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT ALTER ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT UPDATE ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT TAKE OWNERSHIP ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT CONTROL ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT DELETE ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT SELECT ON [dbo].[a] TO [db] WITH GRANT OPTION
GRANT REFERENCES ON [dbo].[a] TO [db] WITH GRANT OPTION
 
----------表 和 视图 具有相同的权限
INSERT                                                    --插入
VIEW DEFINITION                                   --查看定义
VIEW CHANGE TRACKING                       -- 查看更改跟踪
ALTER                                                     ---修改
UPDATE                                                  ---更新
TAKE OWNERSHIP                                  ---接管所有权
CONTROL                                               ---控制
DELETE                                                  ---删除
Select                                                    ---选择
REFERENCES                                          --引用
 
----存储过程 具有的权限
VIEW DEFINITION                                   ---查看
ALTER                                                      ---修改
TAKE OWNERSHIP                                   ---接管所有权
CONTROL                                                ---控制
EXECUTE                                                 ---执行
 
-----标量函数 的权限
 
VIEW DEFINITION                                  ---查看定义
ALTER                                                    ---修改
TAKE OWNERSHIP                                 ---接管所有权
CONTROL                                              ---控制
REFERENCES                                         ---引用
EXECUTE                                               ---执行
 
------表值函数 的权限
VIEW DEFINITION                               ---查看定义
ALTER                                                  ---修改
TAKE OWNERSHIP                                --接管所有权
CONTROL                                            ---控制
REFERENCES                                       ---引用
SELECT                                                ---选择

首先说一下Oracle官方提供的图形化SQL编程工具
oracle sql developer
下载地址：
https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
下载时候需要随便注册一个帐号，很简单，免费，有邮箱就能注册
这个工具类似于MSSQL的SQL Server Management Studio
然后就可以尝试连接到数据库了，除了用户名密码之外，经常会报错的一个问题就是SID的错误。
举个例子：
链接驱动器：oracle.jdbc.driver.OracleDriver
URL：jdbc:oracle:thin:@192.168.0.3:1521:SID
sid可以通过在Oracle服务器上登录sqlplus中执行下列SQL
SELECT   NAME   FROM   v$database;
得到，注意sid是区分大小写的，把url中的sid修改成和select出来的一模一样
另外还需要检查一下监听程序listener
通过net manager检查一下里面的地址，看默认端口等有没有改变
另外保险起见可以设置5组listener
其中 TCP/IP协议
地址：localhost 端口：1521
地址：127.0.0.1 端口：1521
地址：主机名 端口：1521
地址：ip 端口：1521
其中 ipc协议
地址：ip 值：sid
参考：https://jingyan.baidu.com/article/e8cdb32b9d6f5077052bade3.html
使用oracle sql developer操作oracle每一步错误都会有报错代码，百度或者谷歌错误代码，是新手解决问题的一个很好方法。