1"use strict";(self.webpackChunkvelodb_docs=self.webpackChunkvelodb_docs||[]).push([["117317"],{743286(e,n,t){t.r(n),t.d(n,{metadata:()=>i,default:()=>h,frontMatter:()=>a,contentTitle:()=>l,toc:()=>d,assets:()=>o});var i=JSON.parse('{"id":"admin-manual/system-tables/information-schema/user-privileges","title":"user_privileges","description":"View user authorization information.","source":"@site/enterprise_versioned_docs/version-3.x/admin-manual/system-tables/information-schema/user-privileges.md","sourceDirName":"admin-manual/system-tables/information-schema","slug":"/admin-manual/system-tables/information-schema/user-privileges","permalink":"/enterprise/3.x/admin-manual/system-tables/information-schema/user-privileges","draft":false,"unlisted":false,"tags":[],"version":"3.x","frontMatter":{"title":"user_privileges","language":"en","description":"View user authorization information."},"sidebar":"enterprise","previous":{"title":"triggers","permalink":"/enterprise/3.x/admin-manual/system-tables/information-schema/triggers"},"next":{"title":"views","permalink":"/enterprise/3.x/admin-manual/system-tables/information-schema/views"}}'),r=t(474848),s=t(28453);let a={title:"user_privileges",language:"en",description:"View user authorization information."},l,o={},d=[{value:"Overview",id:"overview",level:2},{value:"Database",id:"database",level:2},{value:"Table Information",id:"table-information",level:2}];function c(e){let n={code:"code",h2:"h2",p:"p",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",...(0,s.R)(),...e.components};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)(n.h2,{id:"overview",children:"Overview"}),"\n",(0,r.jsx)(n.p,{children:"View user authorization information."}),"\n",(0,r.jsx)(n.h2,{id:"database",children:"Database"}),"\n",(0,r.jsx)(n.p,{children:(0,r.jsx)(n.code,{children:"information_schema"})}),"\n",(0,r.jsx)(n.h2,{id:"table-information",children:"Table Information"}),"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",(0,r.jsxs)(n.table,{children:[(0,r.jsx)(n.thead,{children:(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.th,{children:"Column Name"}),(0,r.jsx)(n.th,{children:"Type"}),(0,r.jsx)(n.th,{children:"Description"})]})}),(0,r.jsxs)(n.tbody,{children:[(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"GRANTEE"}),(0,r.jsx)(n.td,{children:"varchar(81)"}),(0,r.jsx)(n.td,{children:"The user who is granted the privilege"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"TABLE_CATALOG"}),(0,r.jsx)(n.td,{children:"varchar(512)"}),(0,r.jsx)(n.td,{children:"Always 'def'"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"PRIVILEGE_TYPE"}),(0,r.jsx)(n.td,{children:"varchar(64)"}),(0,r.jsx)(n.td,{children:"Type of privilege"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"IS_GRANTABLE"}),(0,r.jsx)(n.td,{children:"varchar(3)"}),(0,r.jsx)(n.td,{children:"Whether the privilege can be granted to others"})]})]})]})]})}function h(e={}){let{wrapper:n}={...(0,s.R)(),...e.components};return n?(0,r.jsx)(n,{...e,children:(0,r.jsx)(c,{...e})}):c(e)}},28453(e,n,t){t.d(n,{R:()=>a,x:()=>l});var i=t(296540);let r={},s=i.createContext(r);function a(e){let n=i.useContext(s);return i.useMemo(function(){return"function"==typeof e?e(n):{...n,...e}},[n,e])}function l(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(r):e.components||r:a(e.components),i.createElement(s.Provider,{value:n},e.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.