diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-09-24 23:14:25 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-09-24 23:14:25 +0000 |
| commit | c6367df506b6f39b63b5ff85304b5618e0f61fb2 (patch) | |
| tree | 29edd9310d6151b49dc4a7447b634cee380ddbe9 /src/backend | |
| parent | e92bec2844f2da02d217d18cb7260cf04f05c43e (diff) | |
| download | postgresql-c6367df506b6f39b63b5ff85304b5618e0f61fb2.tar.gz postgresql-c6367df506b6f39b63b5ff85304b5618e0f61fb2.zip | |
Change default privileges for languages and functions to be PUBLIC USAGE
and PUBLIC EXECUTE, respectively. Per discussion about easing updates
from prior versions.
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/aclchk.c | 4 | ||||
| -rw-r--r-- | src/backend/utils/adt/acl.c | 8 |
2 files changed, 7 insertions, 5 deletions
diff --git a/src/backend/catalog/aclchk.c b/src/backend/catalog/aclchk.c index 56c9a4fe65c..6741c5a5be7 100644 --- a/src/backend/catalog/aclchk.c +++ b/src/backend/catalog/aclchk.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.77 2002/09/04 20:31:13 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.78 2002/09/24 23:14:25 tgl Exp $ * * NOTES * See acl.h. @@ -481,7 +481,7 @@ ExecuteGrantStmt_Language(GrantStmt *stmt) elog(ERROR, "language \"%s\" not found", langname); pg_language_tuple = (Form_pg_language) GETSTRUCT(tuple); - if (!pg_language_tuple->lanpltrusted) + if (!pg_language_tuple->lanpltrusted && stmt->is_grant) elog(ERROR, "language \"%s\" is not trusted", langname); /* diff --git a/src/backend/utils/adt/acl.c b/src/backend/utils/adt/acl.c index 02d2e6746b5..ffcb6ee891b 100644 --- a/src/backend/utils/adt/acl.c +++ b/src/backend/utils/adt/acl.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/acl.c,v 1.79 2002/09/04 20:31:27 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/acl.c,v 1.80 2002/09/24 23:14:25 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -417,11 +417,13 @@ acldefault(GrantObjectType objtype, AclId ownerid) owner_default = ACL_ALL_RIGHTS_DATABASE; break; case ACL_OBJECT_FUNCTION: - world_default = ACL_NO_RIGHTS; + /* Grant EXECUTE by default, for now */ + world_default = ACL_EXECUTE; owner_default = ACL_ALL_RIGHTS_FUNCTION; break; case ACL_OBJECT_LANGUAGE: - world_default = ACL_NO_RIGHTS; + /* Grant USAGE by default, for now */ + world_default = ACL_USAGE; owner_default = ACL_ALL_RIGHTS_LANGUAGE; break; case ACL_OBJECT_NAMESPACE: |