I\'m using postgresql 8.4 and am having a bit of a problem granting select privileges on a view from a database onwed by a different user when the view uses any of the databases functions.
I\'ve been unable to find a reasonable solution to achieve the following: I wish to have a user that has ALL privileges on a database (or series of databases with the same schema), except for one tab
I\'ve got a lot of tables in a tablespace, nearly 100. I have to grant Select, Insert, Update privileges on all those tables to a user. Is it possible? When I write:
I\'m sure I\'m missing something simple, but I\'ve created the following: postgres=开发者_JAVA百科# \\du
I know that I can use views to grant access to a subset of attributes in a table. But how can I grant access to particular tuples only? Say I have a table of registered students, a use开发者_Python百科
I\'m working on an Oracle9i server in college. I have granted my friend select and insert permissions on a view\'v1\'.
I have a question regarding how to grant privileges MySQL user accounts. I have a MySQL user account, and in my example code I would like to grant privileges to the whole database. When I run the code
I want to know How to grant user access to additional tablespaces in Oracle? , because I have 开发者_如何学编程created two additional tablespaces, one for data and the other for indexes, like this dis
Suppose I\'m logged in as USE开发者_JAVA百科RA, I want to access all the user_* views of the USERB schema, such as user_tables, user_tab_columns. How can I do this? ThanksAll the USER_* tables have an
I create a view: CREATE OR REPLACE VIEW AuthorizationTrainer AS 开发者_StackOverflow SELECT Person.id, Person.login as nick, Person.password as pass
加载中,请稍侯......