We have one database named “Other”, a non GP database.It has some table we need to use within GP.(read/write/edit/delete record)
On our GP Company Database ‘TWO’ we have created a view.
CREATE view [dbo].[VOtherTable001]
select *,ID as Dex_row_id from Other..OtherTable001
Let’s add a button on sales transaction entry window to read the first record of table.
we will give permissions to our view.
grant select , insert, update, delete on VOtherTable001 to almas
Now the next messages we got are
To solve these above issues
Create a new role like below in ‘OTHER’ database .
Create a user loging for user ‘almas’ in ‘OTHER’ database so it could be mapped with TWO user.