Search
 
SCRIPT & CODE EXAMPLE
 

SQL

insufficient privileges while creating view in sql oracle

GRANT CREATE VIEW TO <dbusername>;
Note: run above command after log in as admin.
for admin login: 'connect sys/sys sysdba'
Comment

PREVIOUS NEXT
Code Example
Sql :: prisma transaction 
Sql :: uuid sqlalcomany 
Sql :: how to show current database in mysql 
Sql :: mysql show column type 
Sql :: how to check current root password in mysql 
Sql :: alter check constraint in mysql 
Sql :: oracle INTERVAL DAY to second to number 
Sql :: last date for each user sql 
Sql :: oracle undo usage per session 
Sql :: dump db only triggers mysql 
Sql :: SQL/delete 
Sql :: postgresql inheritance 
Sql :: in sql 
Sql :: import sql file to mysql db using shell commands 
Sql :: mysql workbench change default value 
Sql :: postgresql select top 1 from each group 
Sql :: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails 
Sql :: t sql first and last day of week 
Sql :: substract variable amount of minutes from timestamp postgresql 
Sql :: sql is null and is not null 
Sql :: snowflake insert select 
Sql :: sql server express 
Sql :: get substract count sql 
Sql :: Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets. 
Sql :: sql server function to calculate a percentage 
Sql :: sql server port number 
Sql :: create domain sql 
Sql :: table user postgres 
Sql :: can you write relational algebra into sql queries 
Sql :: oracle sysdba connect as another user 
ADD CONTENT
Topic
Content
Source link
Name
3+5 =