Tags down


Unable to grant role to user

By : jmd239
Date : September 14 2020, 05:00 PM
I hope this helps . I've created a role called CATDX_OWNER_RPT_RL and granted SELECT privileges on all tables within the schema. I've created a new user and granted both CONNECT, CREATE SESSION. Now I would like to assign the role I created to the new user with the following syntax - GRANT ROLE CATDX_OWNER_RPT_RL TO USER. It returns this error SQL Error: ORA-00990: missing or invalid privilege 00990. 00000 - "missing or invalid privilege" , Reinventing the wheel? Omit ROLE.
code :

Share : facebook icon twitter icon

T-SQL How to grant role to user

By : Samiran Roymondal
Date : March 29 2020, 07:55 AM
it fixes the issue After creating roles and granting privileges to them, I want to grant the privileges of a specified role to a user, how to do with it? I tried grant to , but failed.
code :
EXEC sp_addrolemember 'db_owner', 'JohnJacobs'

In Firebird database how do I grant a role to a user with the grant option?

By : Dhara Nandu
Date : March 29 2020, 07:55 AM
I wish this help you The GRANT clause with grant option is only for privileges, not for roles. For roles you need to use with admin option.
code :
GRANT <role_granted>
TO <role_grantee_list> [WITH ADMIN OPTION]
[{GRANTED BY | AS} [USER] grantor]

Grant privilege to role with admin option Vs Grant role to user with admin option?

By : Arjun Tare
Date : March 29 2020, 07:55 AM
I wish this helpful for you CASE1:
grant ROLE1 to USER1 with admin option; means you can grant ROLE1 to other users, regardless what have been granted to ROLE1. Thus grant select any table to USER2; does not work.

T-SQL How to grant role to user with ADMIN/GRANT option in SQL Server 2008

By : Bo Wang
Date : March 29 2020, 07:55 AM
around this issue After creating roles and granting privileges to them, I want to grant the privileges of a specified role to a user with grant option so that the user can grant privileges to others, how to do with it? , The stored procedure sp_addrolemember has 2(two) parameters only:
code :
sp_addrolemember [ @rolename = ] 'role', [ @membername = ] 'security_account'
  grant select on myTbl to AnotherUser as MyRole

Unable to grant select privilege to role I've created

By : vincent
Date : September 14 2020, 08:00 PM
Hope this helps Don't invent your own syntax. Remove both TABLE and ROLE from the GRANT statement.
code :
Related Posts Related Posts :
  • Table ID (PrimaryKey) does not increment in a proper sequence in SQL Server
  • Is there an SQL operator in Amazon Redshift which is working as LIKE and IN operator together?
  • Group by two columns expecting all the values, selected from other table, in second column in oracle
  • Find average number of orders per customer in last three years?
  • REGEXP_SUBSTR Oracle | Extract a string between two delimiters
  • SQL view, default value if null
  • Time offset (Paris-Kuwait) incorrect timezone difference SQL Server
  • How to check period id and last updated value then assign to variable?
  • Update different columns in multiple tables by joining them
  • SQL query that prevents Excel from converting long integer to scientific notation
  • How to make valid combinations of many separate tables with subcombinations
  • SELECTING from same field in 2 column
  • ORA-38104: Columns referenced in the ON Clause cannot be updated c.emp_id
  • TSQL: Case when ... end as '
  • SQL Server trigger that stops rows from being added to a table if one of the columns has a value that is not already in
  • What's the recommended way to do database migrations with Ktor + Exposed (Kotlin)?
  • PL/SQL Autoregressive forecasting
  • Extract data from XML using T-SQL query
  • Splitting a column and adding text value to the numerical value
  • selecting minimum value depending on other value
  • SQL update id in table except rows with duplicate data in column
  • SQL Execute a procedure only when the table is not empty?
  • how to derive filter condition from table rows
  • Adding same ID to same rows
  • ODBC Connection / Crystal Reports
  • Problems with updating column from another table in postgresql
  • Querying a messy table in SQL
  • Marking users as not active if they don't have required records
  • Check constraint depending on another table (mutually exclusive relation)
  • Order by error in create view in SQL Server
  • SQL Double Group by query
  • How to use alias in INSERT query?
  • Exempting sunday from oracle sql script
  • Using SQL CONTAINS with multiple words inside a variable
  • Subqueries vs Multi Table Join
  • How to get an array subquery using postgress sql?
  • SQL: How to group records, when they have different types
  • Passing NULL as Value in Parameter for T-SQL stored procedure
  • sql queries side by side
  • Does ROW_NUMBER() support OVER(ORDER BY 1)?
  • PostgreSQL calculate difference between multi rows
  • multiple where statements in proc sql
  • Find the Week from a date passed as input oracle
  • Get month wise YTD
  • can we use two different queries with CTE table in sql server
  • what is actual difference between or operator and in operator in sql
  • How to improve the execution time of inserting to a table from selecting rows from a table of million rows in ORACLE?
  • How do I Select Counts with Spark SQL Without Getting Errors?
  • SQL Query to Fetch Two Records Per Each ID
  • what is better (if) or (where) in sql?
  • SQL query for output
  • Oracle SQL Developer: stop script running if error
  • SQL distinct column with sum of corresponding value
  • Why any data is shown when I execute this select in sql?
  • mariadb sql select distinct values from json array
  • Trying to get many SQL results into a single table
  • Is there a way to split sql results by year?
  • Unable to grant select privilege to role I've created
  • ORA-30009: Not enough memory for CONNECT BY operation / ORA-01788: CONNECT BY clause required in this query block
  • Case when then in where clause
  • shadow
    Privacy Policy - Terms - Contact Us © 35dp-dentalpractice.co.uk