溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

數(shù)據(jù)庫中必要的建表權(quán)限有哪些

發(fā)布時(shí)間：2021-11-11 11:52:52 來源：億速云 閱讀：162 作者：小新 欄目：關(guān)系型數(shù)據(jù)庫

這篇文章主要為大家展示了“數(shù)據(jù)庫中必要的建表權(quán)限有哪些”，內(nèi)容簡(jiǎn)而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“數(shù)據(jù)庫中必要的建表權(quán)限有哪些”這篇文章吧。


  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

點(diǎn)擊(此處)折疊或打開

  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


以上是“數(shù)據(jù)庫中必要的建表權(quán)限有哪些”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對(duì)大家有所幫助，如果還想學(xué)習(xí)更多知識(shí)，歡迎關(guān)注億速云行業(yè)資訊頻道！

向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手