广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >数据库中必要的建表权限有哪些
  • 585

0
分享到

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

2024-04-02 19:04:59 585人浏览 薄情痞子
摘要

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

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


  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


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

您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: 数据库中必要的建表权限有哪些

本文链接: https://www.lsjlt.com/news/65064.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
  • 数据库中必要的建表权限有哪些
    这篇文章主要为大家展示了“数据库中必要的建表权限有哪些”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“数据库中必要的建表权限有哪些”这篇文章吧。 ...
    99+
    2022-10-19
  • MySQL数据库创建内存表有哪些限制
    这篇文章主要讲解了“MySQL数据库创建内存表有哪些限制”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL数据库创建内存表有哪些限制”吧！　　当内存表...
    99+
    2022-10-18
  • Mysql 中User表的权限字段有哪些
    本篇文章为大家展示了Mysql 中User表的权限字段有哪些，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。　　MysqlUser表的权限字段有哪些　　Select_...
    99+
    2022-10-18
  • 有哪些必须要掌握的数据库与sql基础知识
    这篇文章主要讲解了“有哪些必须要掌握的数据库与sql基础知识”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“有哪些必须要掌握的数据库与sql基础知识”吧！数据...
    99+
    2022-10-18
  • 数据库中的数据表有哪些组成
    这期内容当中小编将会给大家带来有关数据库中的数据表有哪些组成，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。在数据库中，数据表是由表名、表中的字段和表的记录三个部分组成的。...
    99+
    2022-10-18
  • MySQL数据库表中的约束有哪些
    这篇文章主要讲解了“MySQL数据库表中的约束有哪些”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL数据库表中的约束有哪些”吧！MySQL表中的约束(constraint)为了保证数...
    99+
    2023-07-05
  • 数据库grant的授权命令有哪些
    本篇文章给大家分享的是有关数据库grant的授权命令有哪些，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。命令以及权限：usage  ...
    99+
    2022-10-18
  • MySQL数据库的授权原则有哪些
    MySQL数据库的授权原则有哪些，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。服务器重新启动的情况当mysqld启动时，所有的...
    99+
    2022-10-18
  • 必须掌握的数据库面试题有哪些
    本篇内容介绍了“必须掌握的数据库面试题有哪些”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！一、为什么使用数...
    99+
    2022-10-18
  • MySQL数据库中数据表的基本操作有哪些
    这篇文章主要讲解了“MySQL数据库中数据表的基本操作有哪些”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL数据库中数据表的基本操作有哪些”吧！前言：库名、表名、列名等等不能和关键字...
    99+
    2023-06-21
  • 数据库向表中添加数据的方法有哪些
    有多种方法可以向数据库的表中添加数据，其中一些常见的方法包括：1. 使用INSERT语句：可以使用INSERT INTO语句将数据插...
    99+
    2023-08-14
    数据库
  • access数据库的主要特点有哪些
    Access数据库的主要特点有：1. 用户友好：Access采用了图形化界面，使得用户能够方便地创建、编辑和管理数据库，不需要掌握复...
    99+
    2023-08-11
    access数据库
  • Sqlite数据库表的操作有哪些
    这篇文章主要介绍“Sqlite数据库表的操作有哪些”，在日常操作中，相信很多人在Sqlite数据库表的操作有哪些问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Sqlite数据...
    99+
    2022-10-18
  • 数据库中表连接方式有哪些
    这篇文章将为大家详细讲解有关数据库中表连接方式有哪些，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。 1 nested loop join 循...
    99+
    2022-10-19
  • 数据库的分表分库算法有哪些
    这篇文章主要讲解了“数据库的分表分库算法有哪些”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“数据库的分表分库算法有哪些”吧！以下是几种常见的分表算法。1.按...
    99+
    2022-10-18
  • 分布式数据库的重要性有哪些
    本篇内容介绍了“分布式数据库的重要性有哪些”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！记得两三年前，当人...
    99+
    2022-10-18
  • 数据库表分区的作用有哪些
    数据库表分区的作用主要有以下几点：1. 提高查询性能：通过将大表分割为多个小表，可以减少查询所需扫描的数据量，从而提高查询效率。2....
    99+
    2023-10-12
    数据库
  • navicat查数据库有哪些表的方法
    这篇文章将为大家详细讲解有关navicat查数据库有哪些表的方法，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。navicat查数据库有哪些表，有两种方式：一、点击navi...
    99+
    2022-10-18
  • python连接数据库的重要事项有哪些
    这篇“python连接数据库的重要事项有哪些”文章，文中示例代码介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要参考一下，对于“python连接数据库的重要事项有哪些”，小编整理了以下知识点，请大家跟着小编的步伐一步一步的慢慢理解...
    99+
    2023-06-06
  • 数据库视图和表的区别有哪些
    小编给大家分享一下数据库视图和表的区别有哪些，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！区别：1、视图是已经编译好的sql语句...
    99+
    2022-10-18
软考高级职称资格查询
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作