0 - 6 of 6 tags for role

developers in my shop want permission to Create Objects in Production because they say they need to Collect Statistics and drop/recreate indexes but i find that they end up creating many 'backup' tables that take up valuable prod space.  how is this handled in other shops?

Hello.
When the loading processes start I have to disable logon to users, and when the last process ends I have to enable logons.
I'm doing this with a Revoke Logon on all to user_x, and then grant logon on all to user_x;
what I want to know is if I can do this at role level

Hi Masters,

I have some questions on how user access works with respect to object and database level

We have a database where all reporting views are residing. All users were granted Select access at the database level (through role or explicit grant) so they can query any view residing in this database. Now we want to revoke access on a particular view but still let them have access to rest of the views. Below are my questions

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,

Hi,

I want to render portlet content only for "Administrator" "Role" and, render: "Access not allowed" for any other "Role".
What would be the best way to achieve this "if/else"...

Thanks,
Bilal

Hi,
I need the role of a user in my code so can anyone tell me as how to get the role of the current user?

Thanks in advance.