必要的建表权限

最新推荐文章于 2023-07-12 14:46:21 发布
最新推荐文章于 2023-07-12 14:46:21 发布
阅读量360 收藏
点赞数

点击(此处)折叠或打开

  1. grant create table to jirasys
  2. grant execute on schema::dbo to jirasys

  4. use [datayesdb]
  5. GO
  6. --GRANT INSERT ON SCHEMA::[dbo] TO [jirasys]
  7. --GO
  8. use [datayesdb]
  9. GO
  10. GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [jirasys]
  11. GO
  12. use [datayesdb]
  13. GO
  14. GRANT CREATE SEQUENCE ON SCHEMA::[dbo] TO [jirasys]
  15. GO
  16. use [datayesdb]
  17. GO
  18. GRANT ALTER ON SCHEMA::[dbo] TO [jirasys]
  19. GO
  20. use [datayesdb]
  21. GO
  22. --GRANT UPDATE ON SCHEMA::[dbo] TO [jirasys]
  23. --GO
  24. use [datayesdb]
  25. GO
  26. GRANT SELECT ON SCHEMA::[dbo] TO [jirasys]
  27. GO
  28. use [datayesdb]
  29. GO
  30. GRANT REFERENCES ON SCHEMA::[dbo] TO [jirasys]
  31. GO

点击(此处)折叠或打开

  1. -USE [master]
  2. --GO
  3. --CREATE LOGIN [jirasys] WITH PASSWORD=N'XXXXXXXXXXXXX', DEFAULT_DATABASE=[bigdata], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  4. --GO
  5.  
  6. USE [bigdata]
  7. DROP USER [jirasys]
  8. CREATE USER [jirasys] FOR LOGIN [jirasys]
  9. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  10. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  11. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  12. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  13. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  14. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  15. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  16. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  17. revoke ALTER ANY DATASPACE from [jirasys] --
  18. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  19. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  20. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  21. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  22. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  23. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  24. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  25. revoke CREATE AGGREGATE from [jirasys] --
  26. revoke CREATE DEFAULT from [jirasys] --
  27. revoke CREATE FUNCTION from [jirasys] --
  28. revoke CREATE PROCEDURE from [jirasys] --
  29. revoke CREATE QUEUE from [jirasys] --
  30. revoke CREATE RULE from [jirasys] --
  31. revoke CREATE SYNONYM from [jirasys] --
  32. revoke CREATE TYPE from [jirasys] --
  33. revoke CREATE VIEW from [jirasys] --
  34. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  35. revoke CHECKPOINT from [jirasys] --
  36. revoke REFERENCES from [jirasys] --
  37.  
  38.  
  39.  
  40. USE [datayesdb]
  41. DROP USER [jirasys]
  42. CREATE USER [jirasys] FOR LOGIN [jirasys]
  43. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  44. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  45. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  46. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  47. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  48. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  49. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  50. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  51. revoke ALTER ANY DATASPACE from [jirasys] --
  52. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  53. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  54. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  55. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  56. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  57. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  58. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  59. revoke CREATE AGGREGATE from [jirasys] --
  60. revoke CREATE DEFAULT from [jirasys] --
  61. revoke CREATE FUNCTION from [jirasys] --
  62. revoke CREATE PROCEDURE from [jirasys] --
  63. revoke CREATE QUEUE from [jirasys] --
  64. revoke CREATE RULE from [jirasys] --
  65. revoke CREATE SYNONYM from [jirasys] --
  66. revoke CREATE TYPE from [jirasys] --
  67. revoke CREATE VIEW from [jirasys] --
  68. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  69. revoke CHECKPOINT from [jirasys] --
  70. revoke REFERENCES from [jirasys] --
  71.  
  72. USE [DBA_TMP]
  73. DROP USER [jirasys]
  74. CREATE USER [jirasys] FOR LOGIN [jirasys]
  75. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  76. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  77. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  78. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  79. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  80. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  81. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  82. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  83. revoke ALTER ANY DATASPACE from [jirasys] --
  84. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  85. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  86. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  87. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  88. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  89. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  90. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  91. revoke CREATE AGGREGATE from [jirasys] --
  92. revoke CREATE DEFAULT from [jirasys] --
  93. revoke CREATE FUNCTION from [jirasys] --
  94. revoke CREATE PROCEDURE from [jirasys] --
  95. revoke CREATE QUEUE from [jirasys] --
  96. revoke CREATE RULE from [jirasys] --
  97. revoke CREATE SYNONYM from [jirasys] --
  98. revoke CREATE TYPE from [jirasys] --
  99. revoke CREATE VIEW from [jirasys] --
  100. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  101. revoke CHECKPOINT from [jirasys] --
  102. revoke REFERENCES from [jirasys] --
  103.  
  104. USE [DBCenter]
  105. DROP USER [jirasys]
  106. CREATE USER [jirasys] FOR LOGIN [jirasys]
  107. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  108. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  109. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  110. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  111. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  112. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  113. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  114. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  115. revoke ALTER ANY DATASPACE from [jirasys] --
  116. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  117. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  118. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  119. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  120. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  121. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  122. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  123. revoke CREATE AGGREGATE from [jirasys] --
  124. revoke CREATE DEFAULT from [jirasys] --
  125. revoke CREATE FUNCTION from [jirasys] --
  126. revoke CREATE PROCEDURE from [jirasys] --
  127. revoke CREATE QUEUE from [jirasys] --
  128. revoke CREATE RULE from [jirasys] --
  129. revoke CREATE SYNONYM from [jirasys] --
  130. revoke CREATE TYPE from [jirasys] --
  131. revoke CREATE VIEW from [jirasys] --
  132. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  133. revoke CHECKPOINT from [jirasys] --
  134. revoke REFERENCES from [jirasys] --
  135.  
  136. USE [dyedb]
  137. DROP USER [jirasys]
  138. CREATE USER [jirasys] FOR LOGIN [jirasys]
  139. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  140. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  141. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  142. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  143. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  144. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  145. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  146. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  147. revoke ALTER ANY DATASPACE from [jirasys] --
  148. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  149. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  150. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  151. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  152. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  153. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  154. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  155. revoke CREATE AGGREGATE from [jirasys] --
  156. revoke CREATE DEFAULT from [jirasys] --
  157. revoke CREATE FUNCTION from [jirasys] --
  158. revoke CREATE PROCEDURE from [jirasys] --
  159. revoke CREATE QUEUE from [jirasys] --
  160. revoke CREATE RULE from [jirasys] --
  161. revoke CREATE SYNONYM from [jirasys] --
  162. revoke CREATE TYPE from [jirasys] --
  163. revoke CREATE VIEW from [jirasys] --
  164. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  165. revoke CHECKPOINT from [jirasys] --
  166. revoke REFERENCES from [jirasys] --
  167.  
  168.  
  169. USE [news]
  170. DROP USER [jirasys]
  171. CREATE USER [jirasys] FOR LOGIN [jirasys]
  172. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  173. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  174. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  175. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  176. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  177. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  178. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  179. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  180. revoke ALTER ANY DATASPACE from [jirasys] --
  181. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  182. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  183. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  184. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  185. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  186. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  187. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  188. revoke CREATE AGGREGATE from [jirasys] --
  189. revoke CREATE DEFAULT from [jirasys] --
  190. revoke CREATE FUNCTION from [jirasys] --
  191. revoke CREATE PROCEDURE from [jirasys] --
  192. revoke CREATE QUEUE from [jirasys] --
  193. revoke CREATE RULE from [jirasys] --
  194. revoke CREATE SYNONYM from [jirasys] --
  195. revoke CREATE TYPE from [jirasys] --
  196. revoke CREATE VIEW from [jirasys] --
  197. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  198. revoke CHECKPOINT from [jirasys] --
  199. revoke REFERENCES from [jirasys] --
  200.  
  201. USE [spiderDB]
  202. DROP USER [jirasys]
  203. CREATE USER [jirasys] FOR LOGIN [jirasys]
  204. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  205. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  206. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  207. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  208. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  209. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  210. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  211. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  212. revoke ALTER ANY DATASPACE from [jirasys] --
  213. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  214. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  215. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  216. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  217. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  218. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  219. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  220. revoke CREATE AGGREGATE from [jirasys] --
  221. revoke CREATE DEFAULT from [jirasys] --
  222. revoke CREATE FUNCTION from [jirasys] --
  223. revoke CREATE PROCEDURE from [jirasys] --
  224. revoke CREATE QUEUE from [jirasys] --
  225. revoke CREATE RULE from [jirasys] --
  226. revoke CREATE SYNONYM from [jirasys] --
  227. revoke CREATE TYPE from [jirasys] --
  228. revoke CREATE VIEW from [jirasys] --
  229. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  230. revoke CHECKPOINT from [jirasys] --
  231. revoke REFERENCES from [jirasys] --
  232.  
  233. USE [topicdb]
  234. DROP USER [jirasys]
  235. CREATE USER [jirasys] FOR LOGIN [jirasys]
  236. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  237. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  238. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  239. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  240. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  241. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  242. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  243. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  244. revoke ALTER ANY DATASPACE from [jirasys] --
  245. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  246. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  247. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  248. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  249. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  250. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  251. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  252. revoke CREATE AGGREGATE from [jirasys] --
  253. revoke CREATE DEFAULT from [jirasys] --
  254. revoke CREATE FUNCTION from [jirasys] --
  255. revoke CREATE PROCEDURE from [jirasys] --
  256. revoke CREATE QUEUE from [jirasys] --
  257. revoke CREATE RULE from [jirasys] --
  258. revoke CREATE SYNONYM from [jirasys] --
  259. revoke CREATE TYPE from [jirasys] --
  260. revoke CREATE VIEW from [jirasys] --
  261. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  262. revoke CHECKPOINT from [jirasys] --
  263. revoke REFERENCES from [jirasys] --
  264.  
  265. USE [master]
  266. DROP USER [jirasys]
  267. CREATE USER [jirasys] FOR LOGIN [jirasys]
  268. ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
  269. ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
  270. revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
  271. revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
  272. revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
  273. revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
  274. revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
  275. revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
  276. revoke ALTER ANY DATASPACE from [jirasys] --
  277. revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
  278. revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
  279. revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
  280. revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
  281. revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
  282. revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
  283. revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
  284. revoke CREATE AGGREGATE from [jirasys] --
  285. revoke CREATE DEFAULT from [jirasys] --
  286. revoke CREATE FUNCTION from [jirasys] --
  287. revoke CREATE PROCEDURE from [jirasys] --
  288. revoke CREATE QUEUE from [jirasys] --
  289. revoke CREATE RULE from [jirasys] --
  290. revoke CREATE SYNONYM from [jirasys] --
  291. revoke CREATE TYPE from [jirasys] --
  292. revoke CREATE VIEW from [jirasys] --
  293. revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
  294. revoke CHECKPOINT from [jirasys] --
  295. revoke REFERENCES from [jirasys] --
  296.  
  297. use master
  298. grant exec on sys.sp_addextendedproperty to [jirasys]
  299.  
  300. --use bigdata
  301. --grant create table on object::dbo to [jirasys]
  302. --use datayesdb
  303. --grant create table to [jirasys]
  304. --use dyedb
  305. --grant create table to [jirasys]
  306. --use news
  307. --grant create table to [jirasys]
  308. --use spiderdb
  309. --grant create table to [jirasys]
  310. --use topicdb


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16131092/viewspace-2144076/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16131092/viewspace-2144076/

conggong5445
关注
使用位运算来做用户鉴权
YogurtQ的博客
11-25 278
使用位运算来做用户鉴权其实并不是一件新鲜事，已经有不少人讲过了。不过最近在看vue3源码的时候发现vue3在对VisualDOM做patch操作的时候竟然也使用了位运算还进行flag的判断，便忽然来了兴趣，想要好好说道说道。 首先看看来看看vue3源码，已经去除了不必要的注释 patchFlag.ts(Github源码地址) // Patch flags can be combined using the | bitwise operator and can be checked // using the
Sybase安装，配置、建表、建用户、权限.
01-16
本篇文章将详细介绍Sybase的安装、配置、建表、建用户以及权限设置等核心操作步骤。 首先，我们来探讨Sybase的安装。安装过程通常包括以下几个关键步骤： 1. 下载适合您操作系统的Sybase安装包，确保与硬件环境兼容...
权限管理 建表
大蘑菇
01-27 174
[img]http://dl.iteye.com/upload/attachment/199140/3b13d9f1-bb28-3030-8741-a41ef7bbd419.jpg[/img] 见图
mysql 删除赋予用户的权限_java基础之MySQL存储过程和用户管理
weixin_39738380的博客
11-28 337
第四节 存储过程和用户管理4.1 存储过程1. 什么是存储过程通过前面章节的学习，我们已经知道SQL是一种非常便利的语言。从数据库抽取数据，或者对特定的数据集中更新时，都能通过简洁直观的代码实现但是这个所谓的“简洁”也是有限制，SQL基本是一个命令实现一个处理，是所谓的非程序语言。在不能编写流程的情况下，所有的处理只能通过一个个命令来实现。当然，通过使用连接及子查询，即使使用SQL的单一命令也能实...
RBAC 权限管理----之建表
Damys
11-08 4095
建表：管理员表，权限表，角色表， 并模拟数据-- 管理员 3-1 CREATE TABLE admin_manager ( manager_id smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员id', manager_name varchar(32) NOT NULL DEFAULT '' COMMENT '管理员姓名',
新建表时遇到权限的问题
u010263207的专栏
04-15 558
新建一个用户HSIBS,需要赋予grant connect权限给用户才可以登录。 还需要通过管理员dba来赋予建表权限：grant  create table  to HSIBS。 用户HSIBS新建一个表crate table AA时，若HSIBS是dba用户并且登录的时候也以dba的身份登录和建表，则在normal角色登录时是没有表AA的。 遇到这样的问题，我找了好久愣是没找到。
greenplum账号添加建表权限
06-15
3. 运行以下命令，授予该用户建表权限： ``` GRANT CREATE ON DATABASE <database_name> TO ; ``` 其中，`<database_name>`为要授予权限的数据库名称，`<username>`为要授予权限的用户名。 4. 如果需要授予该用户...
mysql建表常用sql语句个人经验分享
09-10
通过上述知识点的总结，可以看出，熟练掌握MySQL建表相关的SQL语句是十分必要的，不仅可以提高工作效率，还能保证操作的准确性，减少因错误操作导致的数据损失风险。在实际使用中，根据实际需求，灵活组合使用上述...
mysql批量导出建表语句.zip
08-15
MySQL批量导出建表语句是一项常见的数据库管理任务，它涉及到数据库备份、迁移或复制到新的环境。...此外，确保在导出和导入过程中考虑数据的完整性、权限设置和数据库版本兼容性等因素，以确保数据的安全和一致性。
品优购建表语句
03-24
“pinyougoudb-v1.3.sql”文件是“品优购”项目的数据库建表脚本，包含了所有必要的表结构和字段定义，用于存储诸如用户信息、商品详情、订单、支付、库存等关键数据。在分析这个SQL脚本时，我们可以了解到数据库是...
用户管理系统（权限管理）建表语句和UML.rar
06-12
用户管理，权限管理模块的数据库表结果和建表语句，包含UML模型。表结构包含用户管理，系统管理，菜单管理，权限管理，角色管理，组管理等
权限的具体实现方法，及建表
男人的累，女人不懂
01-16 163
用户表(user): user_id user_name user_password 职位表(position)： position_id position_name 功能模块表(systemModule): systemModule_id superSystmedule_id(作为一个功能模块...
mysql 增加建表权限,mysql_基本权限模型建表结构
weixin_39626237的博客
03-17 282
建表由于咱们的系统比较简单且权限要求不台复杂，那么我们的表结构也没必要复杂了，就新建5个表就行了1.用户表(user)CREATE TABLE `user` (`id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',`password`...
开发环境下数据库的建表权限的控制
Hello，world！
10-20 550
现在的运行环境既是24小时运行环境，又有很多层次不同的人在上面开发，相当
数据库的建表以及权限基础操作
最新发布
m0_63877940的博客
07-12 745
一些基础的语句收录以及教学，易出错点提醒
GRANT 给存储过程赋权限
热门推荐
mouseshuai的专栏
01-17 4万+
    周所周知，grant是给别的用户赋权限。他不只能够给表，视图赋权限，而且对存储过程，方法，以及包都可以，具体语法参考如下：     1.grant给表赋权限：     grant  select/update on  table to user；     grant  权限 on 表  to 用户。     2.grant 给存储过程赋权限：    
mysql 修改表结构_转载：mysql设计表权限结构
weixin_39717692的博客
11-28 2607
转载自： 用户权限管理数据库表结构设计 - 改变你我 - 博客园实现业务系统中的用户权限管理--设计篇 B/S系统中的权限比C/S中的更显的重要，C/S系统因为具有特殊的客户端，所以访问用户的权限检测可以通过客户端实现或通过客户端+服务器检测实现，而B/S中，浏览器是每一台计算机都已具备的，如果不建立一个完整的权限检测，那么一个“非法用户”很可能就能通过浏览器轻易访问到B/S系统中的所有功能。因此...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值