- Replace [database name]
with your database name.
- Replace [schema name]
with your schema name.
USE [database name] -- enter your database name
GO
CREATE LOGIN birstuser WITH PASSWORD = 'Password1'
GO
CREATE USER birstuser FOR LOGIN birstuser WITH DEFAULT_SCHEMA=[schema name] --enter your schema name
GO
GRANT SELECT ON ACACCTCAT TO birstuser
GRANT SELECT ON ACACTGRP TO birstuser
GRANT SELECT ON ACACTIVITY TO birstuser
GRANT SELECT ON ACBUDDTL TO birstuser
GRANT SELECT ON ACCOMMITX TO birstuser
GRANT SELECT ON ACGLMAST TO birstuser
GRANT SELECT ON ACTRANS TO birstuser
GRANT SELECT ON AMASSET TO birstuser
GRANT SELECT ON AMASTBKDSP TO birstuser
GRANT SELECT ON AMASTBOOK TO birstuser
GRANT SELECT ON AMASTITEM TO birstuser
GRANT SELECT ON AMBKHIST TO birstuser
GRANT SELECT ON AMBKHISTX TO birstuser
GRANT SELECT ON AMBKTRANS TO birstuser
GRANT SELECT ON AMBOOK TO birstuser
GRANT SELECT ON AMDIVISION TO birstuser
GRANT SELECT ON AMLOCATION TO birstuser
GRANT SELECT ON AMTRANS TO birstuser
GRANT SELECT ON APCOMPANY TO birstuser
GRANT SELECT ON APDISTRIB TO birstuser
GRANT SELECT ON APDIVCODE TO birstuser
GRANT SELECT ON APINVOICE TO birstuser
GRANT SELECT ON APPAYMENT TO birstuser
GRANT SELECT ON APVENADDR TO birstuser
GRANT SELECT ON APVENCLASS TO birstuser
GRANT SELECT ON APVENGROUP TO birstuser
GRANT SELECT ON APVENLOC TO birstuser
GRANT SELECT ON APVENMAST TO birstuser
GRANT SELECT ON ARCOMP TO birstuser
GRANT SELECT ON ARCUSTGRP TO birstuser
GRANT SELECT ON ARCUSTOMER TO birstuser
GRANT SELECT ON AROITEMS TO birstuser
GRANT SELECT ON AROPTR TO birstuser
GRANT SELECT ON ARPAYMENT TO birstuser
GRANT SELECT ON AUMXVALUE TO birstuser
GRANT SELECT ON BUYER TO birstuser
GRANT SELECT ON CBBANKINST TO birstuser
GRANT SELECT ON COLINE TO birstuser
GRANT SELECT ON COMMCODES TO birstuser
GRANT SELECT ON CRANALYST TO birstuser
GRANT SELECT ON CUAMOUNT TO birstuser
GRANT SELECT ON CUSTDESC TO birstuser
GRANT SELECT ON CUSTORDER TO birstuser
GRANT SELECT ON FBDETAIL TO birstuser
GRANT SELECT ON FBHEADER TO birstuser
GRANT SELECT ON FRCHARGE TO birstuser
GRANT SELECT ON FRCONTFLDS TO birstuser
GRANT SELECT ON FRCONTMAST TO birstuser
GRANT SELECT ON FRGRPCODE TO birstuser
GRANT SELECT ON FRPREPAY TO birstuser
GRANT SELECT ON FRSALES TO birstuser
GRANT SELECT ON GLAMOUNTS TO birstuser
GRANT SELECT ON GLCHARTDTL TO birstuser
GRANT SELECT ON GLCHARTSUM TO birstuser
GRANT SELECT ON GLCONSOL TO birstuser
GRANT SELECT ON GLNAMES TO birstuser
GRANT SELECT ON GLSRCCODE TO birstuser
GRANT SELECT ON GLSYSTEM TO birstuser
GRANT SELECT ON GLTRANS TO birstuser
GRANT SELECT ON GLUNITS TO birstuser
GRANT SELECT ON ICCOMPANY TO birstuser
GRANT SELECT ON ICHISTORY TO birstuser
GRANT SELECT ON ICITEMCODE TO birstuser
GRANT SELECT ON ICITEMGTIN TO birstuser
GRANT SELECT ON ICLOCATION TO birstuser
GRANT SELECT ON ICTRANS TO birstuser
GRANT SELECT ON INLINETYPE TO birstuser
GRANT SELECT ON INSTCMDTY TO birstuser
GRANT SELECT ON ITEMLOC TO birstuser
GRANT SELECT ON ITEMMAST TO birstuser
GRANT SELECT ON ITEMNDC TO birstuser
GRANT SELECT ON LMLEASE TO birstuser
GRANT SELECT ON MAINVMSG TO birstuser
GRANT SELECT ON MAJCUSTCL TO birstuser
GRANT SELECT ON MAJORCL TO birstuser
GRANT SELECT ON MAREASONCD TO birstuser
GRANT SELECT ON MINCUSTCL TO birstuser
GRANT SELECT ON MINORCL TO birstuser
GRANT SELECT ON OECOMPANY TO birstuser
GRANT SELECT ON OEFRTCODE TO birstuser
GRANT SELECT ON OEINVCLINE TO birstuser
GRANT SELECT ON OEINVCTYPE TO birstuser
GRANT SELECT ON OEINVOICE TO birstuser
GRANT SELECT ON OEREASON TO birstuser
GRANT SELECT ON OESOURCE TO birstuser
GRANT SELECT ON OPERATOR TO birstuser
GRANT SELECT ON ORDERTYPE TO birstuser
GRANT SELECT ON POCOMPANY TO birstuser
GRANT SELECT ON POLINE TO birstuser
GRANT SELECT ON POLINESRC TO birstuser
GRANT SELECT ON POMESSAGE TO birstuser
GRANT SELECT ON PORECLINE TO birstuser
GRANT SELECT ON PORETURNHD TO birstuser
GRANT SELECT ON PORETURNLN TO birstuser
GRANT SELECT ON POREVISION TO birstuser
GRANT SELECT ON POVAGRMTHD TO birstuser
GRANT SELECT ON POVENDOR TO birstuser
GRANT SELECT ON PURCHORDER TO birstuser
GRANT SELECT ON REQHEADER TO birstuser
GRANT SELECT ON REQLINE TO birstuser
GRANT SELECT ON REQUESTER TO birstuser
GRANT SELECT ON RETURNHDR TO birstuser
GRANT SELECT ON RETURNLINE TO birstuser
GRANT SELECT ON SALESREP TO birstuser
GRANT SELECT ON SHIPTO TO birstuser
GRANT SELECT ON STRUCTURE TO birstuser
GRANT SELECT ON SYSTEMCODE TO birstuser
GRANT SELECT ON TERITORY TO birstuser
GRANT SELECT ON TERMS TO birstuser
GRANT SELECT ON TXCODEMAST TO birstuser
GRANT SELECT ON WHDEMAND TO birstuser
GRANT SELECT ON WHDEMNDHDR TO birstuser
GRANT SELECT ON WHPROCTYPE TO birstuser