I have my custom webpart, which have access to database. I need to configure data source, catalog, username and password, which allows webpart a access database. I don't want that users can see, what is account name or password. What is best way manage user rights in SharePoint?
I have thinking couple ways, but I cannot tell are these ideas good and whether there are better ways manage this?
Idea1: I save all neasesery information to list and I somehow hide it from users? (HOW?) Webpart reads this list information and access a database.
Idea2: Hardcode connection string to webpart. However maintenance will suffer.
Idea3: Webpart settings and connection string, but then all users must set it and it will not work.