Data Factory cant see the Stored Procedure in my Azure SQL database

In SQL I have created a user and rule with full access to my schemas

-- Create the user with Password for users that authenticate at the database
CREATE USER DBowner WITH PASSWORD = 'pwrd';

--Im going to create a role and I want that rule to have full access across the schemas
CREATE ROLE db_Owner_full;

--Execute the Stored Procedure addrole member. Here the Org_powerbi user is being added to the above role
EXEC sp_addrolemember 'db_Owner_full', 'DBowner';

--And Grant full access to the schemas

GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: audits TO db_Owner_full;

I have created a Stored Procedure on the audits schema
And My Link Service for the Azure SQL Database has the usename and password as above which works and I can see all the tables

However When I create a Stored Procedure activity it cant see the Stored Procedure. Do I need to do any thing else when I GRANT access in order to see the Stored Procedure?

Thanks in advance