OraFAQ Forum: Server Utilities » creating a table space....in 8i or 8.....?

Home » RDBMS Server » Server Utilities » creating a table space....in 8i or 8.....?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating a table space....in 8i or 8.....? [message #72582]

Wed, 23 July 2003 19:04

shahzad-ul-hasan
Messages: 617
Registered: August 2002

Senior Member

dear sir,
thanks for help me......... you 'r great..
the command is that...
alter tablespace system add datafile 'corantdatabaseshah.dbf' size 50m autoextend on;

would you think that it will work preperly.......
thanks for help

Q.No....2

i want to create a user which can not change his password, by using alter command. with the permission of dba it can change its password.....
thanks for help

........sorry for trouble... but thanks for solve my problems

Report message to a moderator

Re: creating a table space....in 8i or 8.....? [message #72584 is a reply to message #72582]

Thu, 24 July 2003 06:29

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

for question 2:
i beleive, 
you can make use of PASSWORD_VERIFY_FUNCTION.
look into security manual for more detailed information.
You have to create a profile(with password verify function) and assign to the user.

Report message to a moderator

Re: creating a table space....in 8i or 8.....? [message #72640 is a reply to message #72582]

Tue, 12 August 2003 23:10

shesha
Messages: 24
Registered: August 2003

Junior Member

Your first query will work without any problem.

For second question..
I think you cannot restrict the user to change his own password.

Report message to a moderator

i want to create a user which can not change his password, by using alter command. with the permissi [message #73389 is a reply to message #72582]

Fri, 09 April 2004 01:08

CHANDU
Messages: 23
Registered: March 2002

Junior Member

Sir, if u provide this to me it will help in my project work .

thank u,
chandu

Report message to a moderator

Previous Topic:	Numbe Format for SQL*LOADER
Next Topic:	i want to create a user which can not change his password, by using alter command. with the permissi

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:33:36 CDT 2024