0 - 6 of 6 tags for privileges

Hello,
Looking for some advise,

I was wondering if there was a query to enumerate all the databases/tables to which I have access, given I have logged on via LDAP.  The results of querying the X Views, such as dbc.DatabasesVX and dbc.TablesVX do not show all of the databases and tables I have access to, so it would seem a more complex solution would be required.

Hello guys,
 
I am trying to find out a solution/an answer for my problem for some days and my conclusion (till now) is this one: it's possible to grant access for a schema to a role, but nor for its (schema's) content. Please correct me if I am wrong. 
 
Here is my problem:
 

Hi everyone!
I'm new at this forum and I'd like to share a need I have in the company I work.
We are going to migrate our DB2 environment to Teradata, but we have a separated security area where they only grant privileges to users, but they can't create any kind of objects.

I am new to Teradata and trying to set up our developers on a test database. I want to use roles.

This is what I have run:

create database swh_dev from dbadmin as perm=200000000000 NO JOURNAL ;
grant all on swh_dev to swh_dev with grant option;

create role developer;

GRANT EXECUTE, SELECT, INSERT, UPDATE, DELETE, STATISTICS, DUMP,
RESTORE, CHECKPOINT, SHOW, EXECUTE PROCEDURE, ALTER PROCEDURE,
EXECUTE FUNCTION, ALTER FUNCTION, ALTER EXTERNAL PROCEDURE, CREATE
OWNER PROCEDURE, CREATE TABLE, CREATE VIEW, CREATE MACRO,
CREATE TRIGGER, CREATE PROCEDURE, CREATE FUNCTION,