Using a Connection Link
Creation and use of a connection link is dependent on the permissions granted to a user. The following are the permissions that can be granted to users:
CREATE LINK
: A user with theCREATE LINK
permission can create a connection link and only that user will know the connection details.SHOW LINK
: A user with theSHOW LINK
permission can view and use all connection links that exist in a SingleStore DB database.DROP LINK
: A user with theDROP LINK
permission can remove a connection link that exists in a SingleStore DB database.
Note: The listed permissions can be cluster or database scoped. For example, you can grant the CREATE LINK permission on *.*
(cluster scoped) and database.*
(database scoped) but not database.table
. See the GRANT topic for more details.