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

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

1. grant create table to jirasys
   

2. grant execute on schema::dbo to jirasys
   

3. 
   

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
     

311. 
     

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