数据库中必要的建表权限有哪些

这篇文章主要为大家展示了“数据库中必要的建表权限有哪些”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“数据库中必要的建表权限有哪些”这篇文章吧。

成都创新互联是一家集网站建设,汉寿企业网站建设,汉寿品牌网站建设,网站定制,汉寿网站建设报价,网络营销,网络优化,汉寿网站推广为一体的创新建站企业,帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿,时刻以成就客户成长自我,坚持不断学习、思考、沉淀、净化自己,让我们为更多的企业打造出实用型网站。

  1. grant create table to jirasys

  2. grant execute on schema::dbo to jirasys

  3. use [datayesdb]

  4. GO

  5. --GRANT INSERT ON SCHEMA::[dbo] TO [jirasys]

  6. --GO

  7. use [datayesdb]

  8. GO

  9. GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [jirasys]

  10. GO

  11. use [datayesdb]

  12. GO

  13. GRANT CREATE SEQUENCE ON SCHEMA::[dbo] TO [jirasys]

  14. GO

  15. use [datayesdb]

  16. GO

  17. GRANT ALTER ON SCHEMA::[dbo] TO [jirasys]

  18. GO

  19. use [datayesdb]

  20. GO

  21. --GRANT UPDATE ON SCHEMA::[dbo] TO [jirasys]

  22. --GO

  23. use [datayesdb]

  24. GO

  25. GRANT SELECT ON SCHEMA::[dbo] TO [jirasys]

  26. GO

  27. use [datayesdb]

  28. GO

  29. GRANT REFERENCES ON SCHEMA::[dbo] TO [jirasys]

  30. 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

以上是“数据库中必要的建表权限有哪些”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注创新互联行业资讯频道!


本文名称:数据库中必要的建表权限有哪些
链接URL:http://cdiso.cn/article/jcccss.html

其他资讯