ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > SQL Server > 必要的建表权限

必要的建表权限

原创 SQL Server 作者：o0yuki0o 时间：2017-08-24 16:52:59 0 删除 编辑

点击(此处)折叠或打开

  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博客 ” ，链接：https://blog.itpub.net/16131092/viewspace-2144076/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： Logon failed for login due to trigger execution
下一篇： 查看所有外键
请登录后发表评论 登录
全部评论
o0yuki0o

注册时间：2014-02-26

  • 博文量
    90
  • 访问量
    75892

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593