New answers tagged

0

I'd create a dedicated MySQL instance per user (with docker for example) and let them do whatever they want. Your situation maybe different, of course, I'm just sharing an idea.


1

V$LOGMNR_CONTENTS V$LOGMNR_CONTENTS contains log history information. To query this view, you must have the LOGMINING privilege. The LOGMINING privilege was granted to DBA role. When running an anonymous block, all your privileges granted through a role are effective. When running a stored procedure defined with the default definers rights option, ...


0

You need the ability to REFERENCE the table/view in order to include in a precompiled ptogram. For trial and error testing ONLY, you could grant ALL permissions. But, this is a serious security risk.


1

To diagnose, inspect the output of this query before and after reconnecting in your question: SELECT current_user, current_setting('search_path'::text) AS search_path , relowner::regrole, relnamespace::regnamespace, relname, relacl , pg_get_viewdef(c.oid) AS view_definition FROM pg_class c WHERE relname = 'view' -- actual view name OR (...


0

For anyone else who finds this thread, the latest version of this useful script is here: Script DB Level Permissions v4.3


1

Some of the permissions you're trying to change don't exist in the way you're trying to use them. For example, to deny CREATE TABLE and most other DDL statements, for a particular schema, the correct syntax and permission would be DENY ALTER ON SCHEMA::dbo TO MyRole. This should cover the equivalent of the db_ddladmin role's permissions. (I know it's a ...


0

Your ALTER DEFAULT PRIVILEGES needs to be for the role who will be creating the schema, so it needs to be FOR ROLE other_role.


4

Because the new owner don't want to be given an object that a bunch of other people has access to? Imagine buying a new house. Do you expect other folks to have access to your new house? Or would you say that it is up to you to hand out the keys/codes to your new house - to the people you trust? It is hard to respond to "why" questions, since we'd ...


Top 50 recent answers are included