Hello!
You need to have owner credentials in the sharepoint site in order to be able to use the connector. This is something you can review with the Sharepoint site administrator.
On the other hand, there are various ways for Alteryx to validate your credentials when connecting to Sharepoint, you will need to review the tool and select according to your company standards.
Hope this helps.