sql-grant
Grant select on views which use functions
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.[详细]
2023-03-17 02:46 分类:问答MySQL grant all privileges to database except one table
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[详细]
2023-03-11 05:51 分类:问答Grant Select, Insert, Update to a Tablespace
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:[详细]
2023-03-10 02:38 分类:问答Postgres unable to create db after granting privs to role
I\'m sure I\'m missing something simple, but I\'ve created the following: postgres=开发者_JAVA百科# \\du[详细]
2023-03-05 18:56 分类:问答Grant access to subset of table to user on PostgreSQL
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百科[详细]
2023-03-05 18:20 分类:问答Views with Granted Select/Insert Permissions
I\'m working on an Oracle9i server in college. I have granted my friend select and insert permissions on a view\'v1\'.[详细]
2023-03-05 15:39 分类:问答MySQL Grant User Privileges Error
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[详细]
2023-03-03 12:44 分类:问答How to grant user access to additional tablespaces in Oracle?
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[详细]
2023-02-24 00:47 分类:问答how to select a Oracle schema-specific view from another schema
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[详细]
2023-02-04 02:25 分类:问答What is error mysql (#1356)?
I create a view: CREATE OR REPLACE VIEW AuthorizationTrainer AS 开发者_StackOverflow SELECT Person.id, Person.login as nick, Person.password as pass[详细]
2023-02-01 19:21 分类:问答