Réttindi notanda fyrir uppáskriftavef, útgáfa 6 og eldri

Hérna eru réttindi sem notandinn þarf í SQL:
Skipta þarf út <CompanyName> fyrir þau fyrirtæki sem eru í grunninum og nota vefinn
Einnig þarf að skipa út PUBLIC fyrir þann notanda sem á að fá þessi réttindi.
Það er möguleiki á því að einhverjar af þessum töflum séu ekki til í grunninum, þá er það vegna þess að þær fylgja sérkerfum sem eru ekki í notkun hjá ykkur og því má sleppa því að gefa réttindi á þær töflur.


grant SELECT ON "<CompanyName>$Web Translation" to PUBLIC
grant SELECT ON "<CompanyName>$MT Approval Comment Line" to PUBLIC
grant SELECT, INSERT, UPDATE ON "<CompanyName>$Web User" to PUBLIC
grant SELECT ON "<CompanyName>$Web Setup" to PUBLIC
grant SELECT ON "<CompanyName>$Approval User" to PUBLIC
grant SELECT ON "<CompanyName>$MT Approval Setup" to PUBLIC
grant SELECT ON "<CompanyName>$Approval User in Group" to PUBLIC
grant SELECT ON "<CompanyName>$Approval Header" to PUBLIC
grant SELECT ON "<CompanyName>$Approval Line" to PUBLIC
grant SELECT ON "<CompanyName>$Web Option Translation" to PUBLIC
grant SELECT ON "<CompanyName>$MT Approval Comment Line" to PUBLIC
grant SELECT ON "<CompanyName>$Dimension Value" to PUBLIC
grant SELECT ON "<CompanyName>$Approval Invoice Header" to PUBLIC
grant SELECT ON "<CompanyName>$Approval Invoice Line" to PUBLIC
grant SELECT ON "<CompanyName>$Job" to PUBLIC
grant SELECT ON "<CompanyName>$General Ledger Setup" to PUBLIC
grant SELECT ON "<CompanyName>$Job Task" to PUBLIC
grant SELECT ON "<CompanyName>$Approval Rejection Code" to PUBLIC
grant SELECT ON "<CompanyName>$G_L Account" to PUBLIC
grant SELECT ON "<CompanyName>$Account pr_ Approval User" to PUBLIC
grant SELECT ON "<CompanyName>$Customer" to PUBLIC
grant SELECT ON "<CompanyName>$Vendor" to PUBLIC
grant SELECT ON "<CompanyName>$Bank Account" to PUBLIC
grant SELECT ON "<CompanyName>$Fixed Asset" to PUBLIC
grant SELECT ON "<CompanyName>$Item" to PUBLIC
grant SELECT ON "<CompanyName>$Dimension pr_ Approval User" to PUBLIC
grant SELECT ON "<CompanyName>$G_L Account - Allowed Dim_" to PUBLIC
grant SELECT ON "<CompanyName>$Currency" to PUBLIC
grant SELECT ON "<CompanyName>$Reason Code" to PUBLIC
grant SELECT ON "<CompanyName>$Sub-Project pr_ Approval User" to PUBLIC
grant SELECT ON "<CompanyName>$Sub-Project" to PUBLIC
grant SELECT ON "<CompanyName>$Detailed Cust_ Ledg_ Entry" to PUBLIC
grant SELECT ON "<CompanyName>$G_L Entry" to PUBLIC
grant SELECT ON "<CompanyName>$G_L Budget Entry" to PUBLIC
grant SELECT ON "<CompanyName>$G_L Budget Name" to PUBLIC
grant SELECT ON "<CompanyName>$Department" to PUBLIC
grant SELECT ON "<CompanyName>$Web Table Fields Setup" to PUBLIC
grant SELECT ON "<CompanyName>$User Setup" to PUBLIC
grant SELECT ON "<CompanyName>$Web Application Link" to PUBLIC
grant SELECT ON "WebMultipleCompanies" to PUBLIC
grant SELECT ON "<CompanyName>$Dimension Translation" to PUBLIC
grant SELECT ON "<CompanyName>$Language" to PUBLIC
grant SELECT ON "WiseScan_Attachments" to PUBLIC
grant SELECT ON "WiseScan_Modules" to PUBLIC
grant SELECT ON "WiseScan_Companies" to PUBLIC
grant SELECT ON "WiseScan_AttachmentTypes" to PUBLIC
grant SELECT ON "WiseScan_DynNavDocs" to PUBLIC
grant SELECT ON "Photograph_Info" to PUBLIC


í Nav þarf notandinn að vera til sem uppáskriftarnotandi og það þarf að vera hakað í „Má samþykkja fyrir aðra notendur".

Þessi notandi þarf svo að keyra Navision vefþjónustu lagið („Microsoft Dynamics Nav Business Web Serivce“) og keyra AppPool fyrir NavisionWS2009 vefþjónustuna.


Sjá einnig meðfylgjandi skjal.



Halldór Ragnar Guðjónsson
Creation date: 5/3/2016 11:06 AM      Updated: 5/3/2016 11:08 AM
Files
Réttindi_Notanda_Uppáskriftarvefur_V6.docx