Database Reference
In-Depth Information
This technique can also be used for a
SELECT
statement that either
returns results or does not return results.
Public bookmarks
All bookmarks we create are private by default. When a bookmark is created, the
user name using which we are logged in, is stored with the bookmark. Let's
suppose that we choose
Let every user access this bookmark
as shown in the
following screenshot:
This would have the following effect:
• ll users having access to the same database (the current one) will have
access to the bookmark.
A user's ability to see meaningful results from the bookmark depends on the
A
•
privileges they have on the tables referenced in the bookmark.
Users will be able to delete the bookmark.
•
The default initial query for a table
In the previous examples, we chose bookmark labels according to our preferences.
However, by convention, if a bookmark has the same name as a table, it will be
executed when
Browse
is clicked for this table. Thus, instead of seeing the normal
Browse
results of this table, we'll see the bookmark's results.
Search WWH ::
Custom Search