Ask a Question

Cannot grant UNLIMITED TABLESPACE to created user

in Education by
I am using oracle 10g. I have a database user TDM_DD which executes a procedure in which it creates a schema/user and tables in it. While doing so I have to grant 'UNLIMITED TABLESPACE' privilege to the newly created schema. However I am getting error "ORA-01031: insufficient privileges" Need help!! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
You can only grant the UNLIMITED TABLESPACE privilege as a user that is allowed to grant it, such as the SYSTEM user. You will need to give your TDM_DD user the privileges to be able to have it grant the UNLIMITED TABLESPACE privilege to someone else.

Related questions

0 votes
Q: PL/SQL "Where" conditional "WHERE" clause
    I am trying to make a a query against a table and am kind of stuck in constructing the WHERE ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 1, 2022 in Education by JackTerrance
0 votes
Q: Access to SQL: IFF function
    I have not used access before but I have to convert an access query into SQL so I can write a report in crystal ... like this in SQL? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
Q: Access to SQL: IFF function
    I have not used access before but I have to convert an access query into SQL so I can write a report in crystal ... like this in SQL? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
Q: Which is the method used in MongoDB to Grant user?
    Which is the method used in MongoDB to Grant user? (1)db.grantRole() (2)All the Options (3)db.grantRolesToUser() (4)db.grantToUser()...
asked May 23, 2021 in Technology by JackTerrance
+1 vote
Q: Which is the method used in MongoDB to Grant user?
    Which is the method used in MongoDB to Grant user? (1)db.grantRole() (2)All the Options (3)db.grantRolesToUser() (4)db.grantToUser()...
asked Oct 13, 2020 by JackTerrance
0 votes
Q: What is a SYSTEM tablespace and when it is created?
    What is a SYSTEM tablespace and when it is created?...
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
Q: Which of these instance cannot be created?
    Which of these instance cannot be created? (a) Integer instance (b) Generic class instance (c) Generic type ... Generics of Java Select the correct answer from above options...
asked Feb 22, 2022 in Education by JackTerrance
0 votes
Q: Which of these instance cannot be created?
    Which of these instance cannot be created? (a) Integer instance (b) Generic class instance (c) Generic ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 24, 2021 in Education by JackTerrance
0 votes
Q: For which criteria in workflow “time dependent workflow action” cannot be created?
    For which criteria in workflow “time dependent workflow action” cannot be created?...
asked Nov 11, 2020 in Technology by JackTerrance
0 votes
Q: New user cannot login to SQL Azure
    I am creating a new read/write user on SQL Azure as follows: -- Connected to master create login [fred] ... doing wrong or missing? Select the correct answer from above options...
asked Jan 31, 2022 in Education by JackTerrance
0 votes
Q: In a database where the encryption is applied the data is cannot be handled by the unauthorised user without
    In a database where the encryption is applied the data is cannot be handled by the unauthorised user ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: SQL structure such as table names, column names, and so on cannot be escaped, and thus user-supplied structure names are dangerous. This is a common issue in a report-writing software.
    SQL structure such as table names, column names, and so on cannot be escaped, and thus user-supplied structure names are ... issue in a report-writing software. 1. True 2. False...
asked Mar 20, 2021 in Technology by JackTerrance
0 votes
Q: In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
    In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a ... A Simple Transaction Model in chapter Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: What is the use of GRANT option in IMP command?
    What is the use of GRANT option in IMP command?...
asked Dec 18, 2020 in Technology by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...